Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Backing up access 2007

I have a client that needs to perform a local backup of the data tables. I cannot find an easy way to build that into a user friendly process. I have an Add-in from Helen Feddema but that requires use of a menu that I have disabled. Is there a simple routine for backing up the data? OR Is there a way to activate the Addin Menu to run the backup routine in the addin menu?

Thanks for arr your advice.
Mike
0
MikeOsborne
Asked:
MikeOsborne
  • 3
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Is this a split database? If so, then no, there's really no simple method to do this. You must (a) shell out to another process (Access, VB, VB.NET, etc), (b) perform the backup, and then (c) relaunch the database.
0
 
MikeOsborneAuthor Commented:
Yes, this is a split database. The backup would be done as the user is exiting before the database is closed. Do you have a web site where I could find the code?
 Thanks, Mike
0
 
JVWCCommented:
I have used the dbengine.compactdatabase method to achieve the same result in the past. From memory, you need to make sure the tables are not in use.
IE run this from a main menu after all form are closed.
dbengine.compactdatabase C:\folder1\yourbackend.mdb, C:\folder2\yourbackup.mdb

Cheers
JC
0
 
JVWCCommented:
0
 
JVWCCommented:
FYI:
Just dug up the DB where I used this, it was Access97 so no wonder I could not recall the details.
So here is a caveat.
It was designed for a single user only.
Perhaps you could check for the LDB in a multi user environment.

Cheers
JC
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now