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.