I have been told by  an associate that when Access 95 (and presumably JET
3.0) performs a query across more than one table it obtains table level
locks on all tables during the execution of the query, whereas Access 97
(and Jet 3.5) does not.  Can anybody confirm the truth or otherwise of this
statement?

Clyde Davies
DaVinci CTI Ltd.
Nottingham