How to copy/create a new Access DB based on an existin DB without copying the data?

[John James]

I need to create a new Access DB based on one already existing...Henc e, I am attempting to copy the db struture and not the data; It's a yearly db I need to track/create. I looked on this site and deligtfully found a same question (printed below)...I worked through the process suggested to create the new db, but I can only get tables to transfer, or any query or report also transfers as a table??? And I don't have any table or queries in my Navagation Pane.
Sure, probably me, but I an struggling to figure it out, help and thanks.
John


------------------------------------

Irappleb613 Join Date: Aug 2007
Posts: 2
#4: Aug 14 '07

re: Make a copy of an access database

--------------------------------------------------------------------------------


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!