Deleting data from Test System

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

Guest

I've been building a database and inputting dummy/ test data as I go. I'm
now ready (well sort of) to start loading real data.

What's the best way of deleting all my dummy data so I am starting from
scratch.

Thanks for your help
 
Just delete the data manually, keeping in mind the relationships and
referential integrity rules you've setup. Then compact the database.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Or create a new database. Import all the objects from the old database to
the
new one -- but before you click the OK button, click the Options button at
bottom right of that screen where you select the objects. You'll see a
checkbox for Defintiions Only -- check that box and that will leave your
data behind but bring over the tables and their structures.
 
Back
Top