Access Data shows #DELETED

[rwn]

I had an access program written years ago (~7) that ran from an ODBC connection to the database. THis database is now converted to a SQL database and when I converted the Queries / Forms that run from this SQL database, my records returned show #DELETED.

 

[dhookom]

Do your tables have primary keys that are identified in Access? Do you have any yes/no fields with no default set on the field at the table level?

Duane
Hook'D on Access
MS Access MVP

 

[rwn]

Yes, the tables are identified and no fields that are Y or N have no default. What I did to correct, was to set the form to open in Snap Shot View vs Dynaset view.