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
MikeOsborneAsked:
Who is Participating?
 
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
 
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:
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
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.

All Courses

From novice to tech pro — start learning today.