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

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Linking tables access - sql server 2005 4
SQL Database Diagram not showing up as an access object 1
Upsizing to SQL Server 6
Get constant current SQL Server Table data to Access 2000 FE 3
Access 2000 ADP and SQL Server 2005 2
Slow response from MS access report 3
Access 2007 can't connect to SQL Server 1

Top