467,139 Members | 1,390 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,139 developers. It's quick & easy.

Copy an access database and all objects in it


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
  • viewed: 1671
1 Reply
Expert Mod 2GB
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.

Similar topics

42 posts views Thread by Edward Diener | last post: by
1 post views Thread by Chip | last post: by
3 posts views Thread by solar | last post: by
4 posts views Thread by Arno R | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.