Save existing Access db as empty

B

BAC

One of our divsions has a Access db that we would like to implement in a new
location. Is there a way to save a copy of the existing db without any data
so that it can be e-mailed to the new location and they can begin filling it
with their own data?
 
R

Rick B

This is asked very often.

You create a new database and import the objects only (no data).

OR, you can copy the database and then delete the records from the tables.

Search for previous posts if you need more information.

Rick B
 
L

Larry Daugherty

On the backup copy that you are preparing to send to the other site, run
Delete queries on the tables you want to empty. If some of the tables are
lookup tables that may be of value at the other site you may be better off
to leave them populated.

HTH
 
Top