#Deleted

[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)?

 

[Sylvain Lafontaine]

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 .

 

[Michael Wong]

Hi Sylvain,

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

Anyway, will continue with ADP.

Thanks a lot