Unanswered: Linking vs. Importing from PSQL to Access - Field Type Issues
I'm using an ODBC connection to a PSQL database to link these tables into Access. When linking these tables, the numeric field types change to text field types (except for the record ID field). When I import these same tables, however, all the field types are as they should be. What could be the cause?
Both the import and the links are achieved through the same ODBC connection. If I use imported tables, the data isn't real-time.... if I use the linked tables with the text field type, I'd have to recode all my databases else I'll get a data type mismatch. I'm open to any suggestions, thanks!