View Single Post
  #2  
Old April 13th, 2010, 10:08 PM posted to microsoft.public.access.gettingstarted
Daniel Pineault
external usenet poster
 
Posts: 658
Default Copy settings of database

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