Save existing Access db as empty

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

re-linking Access db to new updated SQL 2005 DB 3
Problem openning DB 1
Access 2007 Split Assets db, issue moving to new directory 0
Full access DB on-line 8
dim db as Database 5
Multiple users accessing the DB 1
Access db locked when 2007 user opens it 1
Modifying a DB from multiple systems at the same time? 3

Back
Top