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