Thank you for the Reply,
Yes, access has the TEXT and MEMO data types.
The TEXT data type in Access is limited to 255 characters.
My problem was trying to map any PostGreSQL datatype to the Access-MEMO datatype. Access maps all variations of
PostGreSQL-VARCHAR(n)to Access-TEXT.
I finally found a solution.
1. Make sure to select the 'Text As LongVarchar' option in the PostGreSQL ODBC Driver.
2. The PostGreSQL-TEXT datatype will map to Acess-MEMO datatype (DTS as well).
***(HINT) Using the linked table manager in Access to update modified tables does not work well. If any changes are
madeto a linked PostGreSQL table, the linked table in Access must be deleted and recreated to update the changes.
Thanks to everyone for your replies, and hopefully this note will help someone in the future.
Jeff
