MySQL Forums
Forum List  »  Microsoft Access

Text Field Lengths in MSAccess Reports
Posted by: Adrian Lines
Date: January 15, 2010 06:13AM

I have successfully migrated our tables to mysql from msaccess and everything is running smoothly and reliably apart from when I run reports.
The text fields in the report are being truncated to 256 characters. I have tried changing the field type in mysql but no matter what I try MSAccess seems to recognise the text field as an MSAccess text field (which is limited to 256 characters).

Any ideas ?

ODBC5.1 and Access 2007



Edited 1 time(s). Last edit at 01/15/2010 06:16AM by Adrian Lines.

Options: ReplyQuote


Subject
Views
Written By
Posted
Text Field Lengths in MSAccess Reports
3306
January 15, 2010 06:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.