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

 

[Pat Hartman]

What most non-professionals don't realize is that when working with SQL server or any other RDBMS, you really need at least TWO databases. One for test data and one for production data. Get your DBA to copy the test database without the data to the new production database. Then open you db and using the linked tables manager, change the db to link to the new production db. Now that I think about it, this might not work in an .adp. It would work if you were using an .mdb. With an .adp, you might not be able to swap back ends that easily. I can't try it at the moment so I'm not sure.