Copy an access database and all objects in it

[AccessHunter]

Hi,

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.

Thanks

[Stewart Ross]

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.

-Stewart