By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,110 Members | 990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,110 IT Pros & Developers. It's quick & easy.

#Deleted In All Fields When Linking SQL Server Table In MS Access

P: n/a
I have a set of tables in SQL Server, which, when I link in
Access, I get all the fields displayed as #Deleted when I
look in table view or the output of a query. However, when
I walk the recordset in code, it is just fine, and it displays
correctly in Enterprise manager and Query analyzer.

Looking back in the archives there is some indication of
a problem with respect to autonumber verses IDENTITY fields,
however, even if I do SELECT * FROM Table it shows the same
output, or if I make it purely read only, such as
SELECT Name & ProductID as Info FROM Products, I still get
the same.

The code that walks the table correctly is:

Dim db As Database
Dim rs As Recordset
Set db = CurrentDb()
Set rs = db.OpenRecordset("dbo_Products")
Do Until rs.EOF
Debug.Print rs!ProductId, rs!Name
rs.MoveNext
Loop
rs.Close

I'd appreciate any suggestions or recommendations to fix
this problem.

Thanks in advance.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.