| | |
|
|
|
Reusing an existing database |
|---|
| message from Dave on 13 May 2004 |
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 replied to Dave on 13 May 2004 |
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.
|
| Jeff Conrad replied to Kevin3NF on 13 May 2004 |
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 replied to Jeff Conrad on 13 May 2004 |
<smacks self on forehead>
|
| Dave replied to Kevin3NF on 14 May 2004 |
Thanks to both of you for your prompt responses!
Dave
Worth area DBAs.
database except the
for "Options"
Toolbars"
Import Tables area
records, then I see
database (if still in
tables, you need to
the parent tables.
Dallas/Ft. Worth area DBAs.
database for
|
|
Archived message: Reusing an existing database (MS Access Forms)
