#deleted instead of data in linked SQL Server table

K

Karen S

I am experiencing the problem outlined in MS
Knowledgebase article 293657:
I have linked via ODBC from Access SQL Server. One of
the tables has fields using the UniqueIdentifier field
type and when opened in access, each cell
shows "#deleted" instead of the data.

The article instructs to update the Jet Engine to SP5 or
later - which I did (SP7) but I am still seeing the same
problem.

Any thought on how to resolve this problem would be
appreciated....

thanks!
 
J

Jeff Boyce

Karen

Have you deleted the link to the SQL data/table and re-linked? I've noticed
some difficulties getting Access' Refresh Links to work consistently with
all back-end sources.

Good luck

Jeff Boyce
<Access MVP>
 

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

replacing a link to a SQL Server table with VBA 1
Linking Tables from SQL Server 1
Preparing for SQL Server 2
Re-Seed in SQL Server 8
query links to SQL server and mdb table 1
Problem with Linked Tables in Access 2007 4
Linked SQL Tables don't report Cascading Updates and Deletes 2
Why won't Access assign a Primary Key ID to my linked SQL Table? 2

Top