ODBC to SLQ 2000 linked table yields '#Deleted'

[chipCHE]

Hello All.
I am trying to use Access2000 as a front end to a MS SQL 2000 database.
I have 3 tables in the database I am using. In two of the tables I can view all rows but in one of the tables I only see #Deleted in each column except when I sort and then I only am able to see the first row that shows up in the sort.
all three tables have less than 10 rows each.

Any Ideas?

Regards,
Chip

 

[cmmrfrds]

Does the table have a unique index in the database. If not make an unique index and refresh the link.

 

[chipCHE]

Thank you cmmrfrds.
The table has a primary key. However, it is of type bigint. I read somewhere on the list today about Access having troubles with bigint values.
I will change the bigint to int tomorrow and I will also check to make sure there is an unique index. Since I did not set up an index ( I assumed SQL would build an index on the primary key) this may be the problem.

Regards,
Chip

 

[chipCHE]

Just found a description and an answer for my problem at

http://www.mssqlserver.com/faq/access-deleted.asp

Regards,
Chip