#Deleted

  • Thread starter Thread starter Michael Wong
  • Start date Start date
M

Michael Wong

I have linked a table from SQL Server 2005 Express to Access 2003 to
make a test.
But when I open the table in Access 2003, all fields display "#Deleted"
This is not happening when I link to an SQL Server 2000 database.

Am I missing somthing (patch or else)?
 
Maybe a missing primary key.

Also, if you have made some change to the design of the table after the
linking, then you must refresh the link in A2003 by recreating the links or
using the Linked Tables Manager.

BTW, this newsgroup is about ADP; so if you are using a MDB file with linked
tables then you should ask your question in a more appropriate newsgroup
such as m.p.a.odbcclientsvr .
 
Hi Sylvain,

Yes! It worked with ADP.
With a linked table, it doesn't work. Funny...

Anyway, will continue with ADP.

Thanks a lot
 
Back
Top