Access Lock Files

Posted on 2011-03-16
Medium Priority
Last Modified: 2013-11-29
I have a A2010 application with an MDB backend, the lLDB lock file is removed if a menu screen is displayed that does not have a data source or until a form data source is opened. I can therefore copy/backup my backend MDB data from a menu screen or in the Open event of a form.

I have invoked the same code with a ACCDB backend and the LACCDB behaviour is different it remains present until all forms are closed thus preventing a Filecopy in the form open event.

Does anyone have a method for automating a FileCopy for data backup purposes in a form open event using an ACCDB frontend and backend?

As a note I have been able to circumvent this issue when exiting the application by invoking a Form close of the menu form, running the FIlecopy, then Quitting the application ... but still need the ability in a form open event.
Question by:ynot8669
  • 3
LVL 75
ID: 35154094
Any open Form or other object that is bound to a linked table in the back end ... will result in the LACCDB file remaining present.

If you must ... you can get around this by use the File System Object and the copy commands contained within ... which will copy an open file, although not recommend to do so in general.

You can set a Reference to the Microsoft Scripting Runtime to get access to the FSO.

LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 800 total points
ID: 35154098

Author Closing Comment

ID: 35154609
Great ...thanks for the prompt reply
LVL 75
ID: 35159341
You are welcome.


Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question