By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,220 Members | 1,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,220 IT Pros & Developers. It's quick & easy.

Make a copy of an access database

P: 2
How do I make a copy of an access 2007 database without the data . Any advice would be helpful. Thanks.
Aug 13 '07 #1
Share this Question
Share on Google+
3 Replies


JKing
Expert 100+
P: 1,206
You have posted your question in the Articles section rather than the Forum section.

I have moved it across for you.

MODERATOR.
Aug 14 '07 #2

JKing
Expert 100+
P: 1,206
I'm not running access 2007 but I'm going to assume it's quite similar to 2003. To accomplish this I create a blank database. Go to file> Get External Data > Import. Browse and select the database you want to import. This should bring up a list of all the objects in the database. Select the objects you want to import. There should also be an option group titled "Import tables" with the two options "Data and Definition" or "Definition" only. Selecting "Definition only" will import just the table structure but no data.

Hope this helps.
Aug 14 '07 #3

P: 2
I'm not running access 2007 but I'm going to assume it's quite similar to 2003. To accomplish this I create a blank database. Go to file> Get External Data > Import. Browse and select the database you want to import. This should bring up a list of all the objects in the database. Select the objects you want to import. There should also be an option group titled "Import tables" with the two options "Data and Definition" or "Definition" only. Selecting "Definition only" will import just the table structure but no data.

Hope this helps.
It worked. Thanks for the help!
Aug 14 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.