how to make the DB empty and start the job?

ariansman

Registered User.
Local time
Yesterday, 22:10
Joined
Apr 3, 2012
Messages
157
I have made a database, obviously with some forms, reports, queries and tables. It's size is about 11 megabytes. So far, I have put fake data in tables to see how it works. Now I want to start the job from an empty database. Shall I simply clear the records in tables and start the job? I did this, and expected to have a smaller file, but the empty DB is still at the same file size. Why?
 
Do a Compact & Repair after you purged the data, that will take care of the size problem.

Catalina
 
Another option is to create a new database. Import all the tables, forms, queries etc from the old db to the new db, but indicate that you only want to import the structure and not the data.

Alan
 
Importing to a new database has an advantage of resetting the unseen object counters, autonumbers etc. It is good idea to do this if the databse development process has been long and messy.
 

Users who are viewing this thread

Back
Top Bottom