Row and Table Locks

J

JMNUSS

In Access 97. Is there syntax available, to use in a
query, that will prevent row and/or table locks? I have a
database that is constatntly updating and a report I run
takes forever to complete. When no data is coming through
the report runs extremely fast. Any ideas?

Thank, Jordan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Consolidation Table from Different Excel Tabs with Different Format 1
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Query performance Access 2007 1
Queries & table locking 4
query to show where no data in a stated column 0
How do I clear a form? 0
Query on SQL Server is fast, while Access is crawling 2

Top