Copy structure not data (1 Viewer)

[jfisher4]

I have developed a database for multiple users and am now ready to release it. As this is a very large database and my first attempt at something of this type, I have entered many records for testing throughout development. I have also set up the security already. I want to copy the database structure without the data to begin clean. I have tried to import all the objects with the table definition only selected but I receive a message that I do not have permission to perform this. I would very much appreciate any help with this.

 

[KevinM]

Wouldn't it be easier to just make a copy of the db and then simply delete ALL data from the tables (and compact it too).

 

[jfisher4]

Since I'm new at this I wasn't sure what was the best way. I did notice that the size remains the same when you delete the records. How does one compact?

 

[KevinM]

From the menu bar, select Tools, Database Utilities, Compact

You should do this on a regular basis, esp at dev stage.

When it goes live you can only do it when nobody else has the db open. (pref open it in EXCLUSIVE mode).

 

[neileg]

As Pat Hartman said in a recent thread

Both the import/export wizard and the copy command offer the option of copying/importing/exporting structure only.

 

[jfisher4]

Neil, it was after reading the post you are referring to that I was attempting to import structure only but was running into trouble with permissions.
Thanks to you both for your help.

 

[Pat Hartman]

Another reason for not starting a new thread. Not only does it waste our time, it makes it harder for you to actually get a resolution.

 

[neileg]

QED, Pat.