New answers tagged ms-access
"Another user is currently using this record" is a misleading error message Access loves to throw out - many times it really indicates you have the table open in another window.
Setting up an Access DB as a linked server gets pretty ugly, but if you absolutely have to do it, you can split that one table into a separate database file, and create a linked table pointing to it from the original Access DB file. Then set up a linked server in SQL Server pointing to the Access database file with that one table. Better option: Build an ...
It could be a mechanism within MS Access when it comes to the linked table. How ??? MSAccess sees a linked table and you issue this: DELETE FROM [mytable]; This will not run over to SQL Server and do a deletion of all records in a single transaction. What MSAccess does is pick up every PRIMARY KEY and issues an individual DELETE FROM [mytable] WHERE pk = ...
Top 50 recent answers are included