keeping database skeleton

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am a novice user with a database I spent some time developing. I
would like to create a new version of this database with the same skeletal
structure but no data so I can enter this year's version of the same data.
Can you help me in how to do this?
 
You can do this by creating a new, blank database, then selecting File >
Import and select your current database. On the import dialogue box that
opens, select the Options buttion and click the radio button for Definition
Only in the Import Tables section.

Now, having told you that, let me encourage you to take a better approach.
DON'T create a new database for each year. Rather, put date fields in all
the appropriate tables and then just query the information you need for a
given year.
 

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

Back
Top