Been migrating some Access data to SQL Server lately. Experienced a previously unencountered experience this morning.
Opened a table in Access that contained #DELETED in every field and every row of a linked SQL Server table. Went to SQL Server, and all of the data I imported to the table yesterday is there. Went back to Access, deleted the linked table, performed a Compact and Repair, closed the database, opened the db, relinked the SQL Server table and still have the same problem.
all of the other tables linked to that SQL Server are working correctly, and the one that is experiencing a problem only has about 2000 records.