Access 97/SQL 2000 - Data in Table show as: #Deleted

  • Thread starter Thread starter Jado
  • Start date Start date
J

Jado

Hi

we're just starting to think of moving to SQL 2000, so i'm running some
initail tests.

When i link to a table i've created in SQL Server 2000 from Access 97 /
2000, all columns and all rows show as: #Deleted

when i create a form based on the tables, sometimes the data shows ok, and
somtimes not!

any idea's....?

thanks

Jado
 
I think i've solved this by looking at another artical in the ODBC Newsgroup

it seems to be a primary key data type problem.

Jado
 
Back
Top