Deleting records and autonumbering question

[Guest]

hi,

I run an organization that functions primarily during the school year. We
have a large Access database (Access 2003) that contains the records of
requests we receive, and I would like to create a new db separate from last
year's requests. I've done this by saving the database with a new name and I
would like to remove all of last year's information (which has been backed
up) so I can start fresh with this year's info.

The db consists of a number of tables and related forms for entering
information. I can delete the records from the table, but when I look at the
form, all the information is still there. For example, I have a table called
'T_RequestInformation' and a form called 'Speakers Bureau Requests'. Info
entered into that form goes into that table, but when I delete the records
from the table, the associated information is still in the form.

Basically, what I would like to do is wipe certain tables and forms clean
(and have their auto-number reset) , and maintain others. What is the correct
way to do this?

Thanks!

alia

 

[Guest]

You'll need to go through all the tables and delete all the records. Then do
a compact and repair.

If you are deleting records from a table, yet the data from that table still
shows up, you are (1) not actually deleting the records or (2) deleting the
data from the wrong table. The second option can happen easily if you are
using a split database with the tables linked to the database.

In general creating a new database for certain time periods, like a year, is
a bad idea. Some day someone will want to compare and contrast this year's
data to previous years. That's very difficult if you have data in multiple
database files.