Hi hope someone out there can help me. I've already tried doing a keyword search on this issue and I didn't find any helpful answers.
I have an Access97 database with linked SQL server tables. When I try to delete a row in the SQL table I get the famous "You and another user are attempting to change the same data at the same time" error message.
This started after I ran an Access query against the table to try and update some rows. The query failed because of key violation errors.
I've already tried compacting and repairing and it didn't help. I've also tried linking the table into a completely blank Access database and I still receive the error in that database.
Any ideas? Maq![[americanflag]](/data/assets/smilies/americanflag.gif "[americanflag] [americanflag]")
<insert witty signature here>
I have an Access97 database with linked SQL server tables. When I try to delete a row in the SQL table I get the famous "You and another user are attempting to change the same data at the same time" error message.
This started after I ran an Access query against the table to try and update some rows. The query failed because of key violation errors.
I've already tried compacting and repairing and it didn't help. I've also tried linking the table into a completely blank Access database and I still receive the error in that database.
Any ideas? Maq
<insert witty signature here>
