Incorrect field sizes Mcaccess 2000

K

Kathy M

I have a db of links to flat files on Unix using ODBC.
When opening up the tables in Access, the tables show the
correct data and field sizes when viewing these linked
tables in '97. When looking at them with 2000, some of
the tables (not all of them) show table field sizes as 1
and the data as "#delete".

I have tried relinking and resetting ODBC.

I also use EasySoft and am able to see correct views of
the same data.

The database of links was moved to a new server a couple
of weeks ago. This seems to be when the problem began.
Does anyone have any idea as to what could be causing this
problem????

Thanks,
 

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

Table linked to ODBC 3
SQL Custom Data Types Not Visible In Access Linked Tables 1
Visual FoxPro via ODBC, #Deleted records, yet works in Excel 1
Link to ODBC - stumped our engineers 3
Linked SQL table pulls all numbers as positive 0
Linking ODBC table results in Decimal field size for Number type in Access 2002 1
ODBC SQL Error Bulk Insert - Null values 1
*@!? Numeric Field Overflow 2

Top