I have MS Access 97 linked to a large SQL Server 6.5 table and I keep getting #Delete for some records. When I check SQL Server these records are still there. The SQL Server table is fairly large (200,000 records of 120 bytes each) it has a clustered index only on the primary key and no other indexes. Any ideas?
