Access 2003 truncating data using ODBC import

R

RogerinTexas

I have Access reports that bring in data from Lotus notes via ODBC. In
Access 97, I get 250 characters per field imported through ODBC link tables.
With Access 2003, using the same ODBC driver and databases, Access truncates
the fields at 200 characters. I need the rest of these fields - any idea how
to fix?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Table Security in Access 2013 1
Access 2007/sql2008 ODBC issue 1
Importing FoxPro 2.6 DBF Into Access 2007 1
Visual FoxPro via ODBC, #Deleted records, yet works in Excel 1
TransferSpreadsheet method question 2
Using ODBC import 1
split data base using ODBC connection 1

Top