Copy Database

[livvie]

I need a clean copy of my database that includes everything except the data. I want to keep the keys and relationships etc. How do I do this? I am using Access 2003 Projects and SQL Server.
I tried Importing the tables with the option Definition only but the option to include relationships is greyed out.

 

[ReAn]

Make new db

Import all your queries/forms/reports/modules/macros

then import your tables, and select the option @ the bottom "Import Structure only"

 

[monkeytunes]

ReAn's will work, but you can cut it down a step and get a bit more flexibility. Go to File->Get External Data->Import, and then choose the database and everything you want to import. There's an Options button, and from there you can designate how you want things imported, and if you want tables to have the data or just the structure. This window also lets you import Menus and Toolbars, or change Queries to Tables if need be.

 

[livvie]

This works except the option to import relationships is greyed out and I only get the tables. Queries or views are not copied. I am using Access 2003 Projects and SQL server