By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,560 Members | 2,989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,560 IT Pros & Developers. It's quick & easy.

Copy an access database and all objects in it

P: 77

I am trying to find a way to copy an access database and all the objects in it.
I need to make a copy of an existing database and modify some tables for each Fiscal Year. The whole manual process invlolves 10-12 steps. I am trying to automate this process and for that the first thing I need is a fresh copy of the current database, which I am not sure how to create one using a VBA code.

Please help.

Jul 25 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
Hi. I don't know of a way to create a copy of the DB using VBA. I don't see the need to try to automate in code this one-off process when there are existing ways to create backup copies.

You don't mention the version you are using. In Access 2003, select Tools, Database Utilities, Back-Up Database to create an exact back up copy of the current database.

Jul 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.