Access Link Table to SQL Server2000 yields #DELETED

[dbrew0]

I have a SQL Server2000(sp3) database with a table that I want to link to an Access 2000 table using a Link Table. When I create the table in Access using link table, all of the data (regardless of datatype) within the newly created Access table shows as #DELETED. I am linking via ODBC. If I use the same ODBC connection and create the table within Access as an import table, the data is correct. I'm stumped. Any ideas?

Thanks in advance.

Dan

 

[cmmrfrds]

Do you have an unique index set up in the sql server table? Make sure you set this unique index when you make the odbc connection.

 

[dbrew0]

Yes I do have unique indexes set up for the table. I did finally figure out what the problem was - I had a bigint in a field's datatype and that field was a primary key. Access couldn't handle the bigint datatype (64 bit) and converted it to text.

You'd think it would flag it as an error and report what the problem was rather than just fill all of the fields with #DELETED.

Thanks for your suggestion.
Dan