We have an Access 2007 database in which we are happy with all of the
settings, etc. Is there a way to create a new database with these same
settings? There is a lot of data in the database. In other words, we want
everything just as it is but without the data.
--
shel

You could make a copy of your database and then use a function such as

http://www.devhut.net/index.php?lang...02#wipeAllTbls

to wipe all your tables clean and then perform a compact and repair.

Make sure you make a backup copy of your db before doing anything like this!!!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"shel" wrote:

> We have an Access 2007 database in which we are happy with all of the
> settings, etc. Is there a way to create a new database with these same
> settings? There is a lot of data in the database. In other words, we want
> everything just as it is but without the data.
> --
> shel