#DELETED displayed in all cells

I have a SQL 2000 database and I'm using Access 2003 to gain access to the
tables. All cells contain #Deleted.
What am I doing wrong?
TIA
Jon
Jon Paskett wrote:
> I have a SQL 2000 database and I'm using Access 2003 to gain access to the
> tables. All cells contain #Deleted.
> What am I doing wrong?
> TIA
> Jon
>
Does it show fine when you use Access 2000 with the database?
Anyway, most probably you have problems with primary keys - i had it couple times when i was using a
table from ODBC connection and primary key was set to the column of UNIQUEIDENTIFIER mssql type.
When i added an INT index column and set it as a primary key, everything works fine!
Also try to link those access 2000 table to a blank database created in Access 2003.
Let me know how it works!
Also if you post what columns (types) do you have in the table, i can have a look.
WYGL,
Andrey