If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy settings of database
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|