How can I dump all Test Data from My Access 2000 Database

C

Curtis

I got an Access 2000 Database and I want to copy all the tables, forms,
queries, reports and macro's without the current data into a new database.
How can I do this?
 
J

jl5000

In the new database select all the objects from the original database to
import (File\Get External Data\Import), in the tables tab click "Options>>",
then select "Definition Only", and then OK to start import
 
J

Jeff Conrad

in message:
I got an Access 2000 Database and I want to copy all the tables, forms,
queries, reports and macro's without the current data into a new database.
How can I do this?
Click to expand...

1. Create a new blank database

2. File | Get External Data | Import

3. Browse to your existing file and hit Import

4. Click on each tab and hit Select All

5. Click the Options>> button

6. Check "Relationships" and "Menus And Toolbars" from the Import area.

7. Select "Definition Only" on the Import Tables option

8. Hit Ok and watch everything fly in.

9. Set any Startup properties you need on this new file. Tools | Startup.

10. You're done!

Hope that helps,
 
Top