Creating Access 2007 Database Question

M

MLyons10

I am not sure where to post this question. I remember finding a forum just
for Microsoft Access 2007 questions, but I couldn't find it again...
Indifferent

Anyway, I have created a database, and have been testing it with my
application. I have some data in this database. I was wondering if there
was a way in Microsoft Access 2007 to create an empty copy of the database
for release. In other words, I would like to create a copy of the database
with all of the tables and columns, but without the data (rows) that I had
entered as part of using my testing database...

Does anyone know if I can do this?

If anyone knows where this Access 2007 forum is, or resources that might
answer my question, please let me know, as I would greatly appreciate that.

Thanks Again,
 
A

Arvin Meyer [MVP]

On the Ribbon: External Data >>> Export

Then you should be able to export to another database. There is an option to
send the Structure Only.

Alternatively:

1. Make a copy of the database file.
2. Delete all the data in the tables, always starting with the many-side of
any relationships.
3. Compact the database.
 
M

MLyons10

Thank you very much for your response, that was very helpful. I could not
find a way to do that for the life of me... :)

Thanks Again,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top