08-29-03, 11:29 #1Registered User
- Join Date
- Sep 2002
Unanswered: Access97 to SQL Server Table Locks
Hey all! Anyone know how you can prevent an Access97 query from locking tables its linked to with ODBC? We have found that setting the lock level in the Access database properties seems to only be effective with Access tables and not linked tables.
Upgrading Access is not an option at this time.
-thanks in advanceWhen in doubt just ask your self,
(what would Sponge Bob do?)