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

[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?

 

[Rob]

Curtis

Create a new database.
From the menu: File -> Get External Data -> Import.
Select the database.
Select the objects you want to bring into the new database.

HTH
Rob

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/

 

[Guest]

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

 

[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?

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,