Copying a current database

N

NoviceIan

We are currently using a Access 2003 database which has several thousend
records in it. I would like to create a blank copy of this database. Is
there any way I can do this without having to copy it then delete all the
records currently stored in it?

Ian
 
N

Nikos Yannacopoulos

Ian,

Start by making a new, blank database. Go File > Get External Data >
Import, and select the old database. When the import wizard window comes
up, click on Options >> and change the Import Tables option from
Definition and Data to Definition Only; if you have any custom Menus and
Toolbars or Import/Export specs, click accordingly on the left. Then
Select each tab in turn on the top, and click Select All on each one.
When done, click OK. When the import process is finished, you will have
a database that is almost an identical copy of the original, without the
data. I say "almost" because there are still two things to be done: (a)
if you had changed any of the default settings in Tools > Startup in the
original database, repeat here; likewise (b) if you had made any
addition to the default VBA references, repeat here.

HTH,
Nikos
 
R

Rick Brandt

NoviceIan said:
We are currently using a Access 2003 database which has several
thousend records in it. I would like to create a blank copy of this
database. Is there any way I can do this without having to copy it
then delete all the records currently stored in it?

Ian
Click to expand...

Create a new blank database and then import all objects from the original. The
import wizard has an option for "Structure Only" for the tables.
 
N

NoviceIan

Thats awesome thanks very much.

Nikos Yannacopoulos said:
Ian,

Start by making a new, blank database. Go File > Get External Data >
Import, and select the old database. When the import wizard window comes
up, click on Options >> and change the Import Tables option from
Definition and Data to Definition Only; if you have any custom Menus and
Toolbars or Import/Export specs, click accordingly on the left. Then
Select each tab in turn on the top, and click Select All on each one.
When done, click OK. When the import process is finished, you will have
a database that is almost an identical copy of the original, without the
data. I say "almost" because there are still two things to be done: (a)
if you had changed any of the default settings in Tools > Startup in the
original database, repeat here; likewise (b) if you had made any
addition to the default VBA references, repeat here.

HTH,
Nikos
Click to expand...
 
Top