#Deleted

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Wong - 08 Dec 2005 10:03 GMT

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

Reply to this Message

Sylvain Lafontaine - 08 Dec 2005 17:12 GMT

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 .

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

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

Reply to this Message

Michael Wong - 21 Dec 2005 02:03 GMT

Hi Sylvain,

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

Anyway, will continue with ADP.

Thanks a lot

> Maybe a missing primary key.
>
[quoted text clipped - 5 lines]
> tables then you should ask your question in a more appropriate newsgroup
> such as m.p.a.odbcclientsvr .

Reply to this Message