Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
QUERY LOCKS ACCESS DATABASE
Yes, as a matter of fact. I am using two tables. I fixed the issue by sepatating them into 2 separate querys. Seems to work slick now. Thanks for the input! Jeremy- TORN
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
QUERY LOCKS ACCESS DATABASE
Thank you for the suggestion. I have tried running this database on multiple systems, all above a 350 processor and 128Mb RAM. This database is not on the network. I have noticed a consistancy with this problem. I have a "print preview" button on this search form also. When I click...- TORN
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
QUERY LOCKS ACCESS DATABASE
Hello, I have a Query that is very complex and is based on several checkboxes and date parameters. When I attempt to run the query it completely locks the database I am working with. I am the only one in the database at the time so it is not a record lock. If anyone can help or give...- TORN
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
