Reusing an existing database

[Dave]

We have an existing Access 2000 database. We would like
to use it for another project without the existing data.
What is the best way to prepare an existing database for
reuse of this sort? I presume I should not open all the
data tables and delete the records.

 

[Kevin3NF]

If you don't need to do anything other than remove records, then I see no
problem with deleting them directly from the tables. This assumes of course
that you are working on a copy of the existing database (if still in use).
Do not delete records in ancillary (lookup) tables, such as state,
customertype, etc.

If you have defined referential integrity between tables, you need to start
with the loweest child table and work your way up to the parent tables.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Jeff Conrad]

If everything will be exactly the same for this "new" database except the records I would think the
easiest thing to do would be this:

1. Create a new blank database
2. Go to File--Get External Data--Import
3. Navigate to the "old" database
4. On the Import Objects screen hit the button for "Options"
5. Check the boxes for "Relationships" and "Menus And Toolbars"
6. Make sure the "Definition Only" is selected on the Import Tables area
7. Then go to each object tab and hit the "Select All" button
8. Then hit OK. Everything should come flying in
9. Compile the database, make any Startup changes, and compact the database.
10. Poof, all done

 

[Kevin3NF]

<applause> much better answer....

<smacks self on forehead>

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Dave]

Thanks to both of you for your prompt responses!

Dave