10-20-2014, 09:25 AM #6 AOB Newly Registered User Join Date: Sep 2012 Location: Dublin, Ireland

why WOULD another user be using the staging table for a process? So make sure table is not open in datasheet view. Join & Ask a Question Need Help in Real-Time? How To Close A Table In Access Go to Solution 2 2 Participants mbizup(2 comments) LVL 61 MS Access60 minamina6 3 Comments LVL 61 Overall: Level 61 MS Access 60 Message Active today Accepted Solution by:mbizup mbizup

ms-access ms-access-2010 share|improve this question edited Mar 6 '13 at 15:39 asked Mar 6 '13 at 15:27 Matt Hall 1,52151646 add a comment| 1 Answer 1 active oldest votes up vote Here's the code for this (for brevity I've summarised all the Make Table scripts that run prior to the FileInfo as some bogus "AllOtherMakeTables" string) Private Sub Command0_Click() On Error GoTo All we did created a new database and import all the tables, forms, query etc. (do relationship if u have to). http://deftmag.com/the-database/the-database-engine-could-not-access-the-file-called-edb-log.html In all the report, we shouldn't allow record lock on the report.

Another suggestion is to make sure you Compact-Repair and backup your database on a regular basis, at least once a day when you finish for the evening. How to stop cups sticking to placemats In java, why POSITIVE_INFINITY, NEGATIVE_INFINITY constants are defined only for floating point data types but not for Integral data types What does this symbol instead of linking to table directly, you can make a query out of that table and use that query. Launch report from a menu, considering criteria only when it is filled… MS Office Office 365 Databases MS Access Advertise Here 643 members asked questions and received personalized solutions in the

Aug 13 '07 #4 reply P: 19 ewarts No codes just the access standard procedures. I tried reinstalling the software but receive the same message, even during installation. I get the following message when i clicked on a button: "database engine could not lock table 'DIVISION' because it is already in use by another person or process" The form Instead of DoCmd.RunSQL, use the DAO database .Execute method for your other queries.

In a way I am dealing with the records, but I thought that after I append the records the table should have been released. Any locks should be retained for an absolute minimum time, and you need to guard against deadlock and similar issues. Join & Ask a Question Need Help in Real-Time? How to select a number from all the integers list?

Aug 16 '07 #8 reply Expert 100+ P: 1,384 Scott Price Scott, I think what's happening here is, when the firm runs a daily back while the file is being updated Member Posts: 32 Country: Karma: +1/-0 Re: "The database engine could not be opened. What is the difference between l() and url()? The Mitel resource - by techies, for techies...

To basically give the DB a chance to catch up on itself.