I have an access database, 2000, linked to SQL tables.
The primary SQL table includes some memo fields.
When I open the table in access, the memo fields are shown in full but when I include that field in a query the field is truncated to 255 characters.
The query selects all the fields from the main table and adds other information from other tables.
I have tried using a query to make a...
User Profile
Collapse
-
Truncation of an SQL memo field
-
Have you tried attacking it from the other end?
Something like WorldMerge ($59) will create emails using Outlook picking up the details of the email address etc from an access query or table.
No activity results to display
Show More
Leave a comment: