Linking vs Importing using ODBC connected database

[Guest]

I have established an ODBC connection to a remote database (SQL), via a vpn
connection.

Using this ODBC driver, I have been trying to link tables from this
database. In doing so, the links work OK (the tables are linked, and the
correct fields names, descriptions and numbers of records exist), but all the
record field data displays as #deleted#. Interestingly, using the same ODBC
driver, and IMPORTING the tables (rather than linking) works fine - all the
record fields display the corrent values.

Any ideas?

 

[Rick Brandt]

I have established an ODBC connection to a remote database (SQL), via
a vpn connection.

Using this ODBC driver, I have been trying to link tables from this
database. In doing so, the links work OK (the tables are linked, and
the correct fields names, descriptions and numbers of records exist),
but all the record field data displays as #deleted#. Interestingly,
using the same ODBC driver, and IMPORTING the tables (rather than
linking) works fine - all the record fields display the corrent
values.

Any ideas?

This can happen if the primary key contains a field with a DataType that doesn't
map directly to an Access DataType (BigInt for example can do this). You would
probably find that a passthrough query also works just fine.