Database archive

S

Stanley

I am trying to write an archive for an Access 2002 database. To make this
simple I'll explain my problem as if I am working with 1 table.
I use a make query to select old records and archive them into another
table. Then I use a query to delete the records I just archived.
Here is my problem:
When I need a record from the achived table, I insert it back into the
original table. I am using autonumbers and suppose the number of the inserted
record is 28 and the last record in my table is 204. When I add a new record
I want the next number to be 205. Instead the next number becomes 29. This
doesn't alway happen.
Any ideas,
Thanks,
Stanley
 
S

Stanley

The idea is to reduce the size of the database. If one of the archive records
is needed, I want to bring it back. This is where I have the autonumber
problem.
Thanks,
Stanley
 
A

Amy Blankenship

Stanley said:
The idea is to reduce the size of the database. If one of the archive
records
is needed, I want to bring it back. This is where I have the autonumber
problem.
Click to expand...

If you want to reduce the size of the table, then simply keep all of the
records in _one_ table ;

Amy
 
A

Amy Blankenship

Amy Blankenship said:
If you want to reduce the size of the table, then simply keep all of the
records in _one_ table ;
Click to expand...

Oops, somehow the rest of the post didn't make it.

it should be:

....and then use another field in the table to set whether or not the record
is archived.

HTH;

Amy
 
Top