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 advance