Solved

Access Lock Files

Posted on 2011-03-16
4
894 Views
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.
0
Comment
Question by:ynot8669
  • 3
4 Comments
 
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.


Capture1.gif
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 200 total points
ID: 35154098
0
 

Author Closing Comment

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

mx
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now