Database archive

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

Guest

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
 
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
 
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
 
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
 
Back
Top