Autonumber question

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

Guest

I was trying to write an archive for an Access 2002 database. I was able to
copy all related records to another database for a given entity and then
delete them from the original database.

If a user wanted to see old entities they could go to the achive. The
problem I have is that if I wanted to put back an entity with all its related
records, I couldn't insert the records into my original database.

I ran into a number of problems. For example, I was able to insert record
number 25 and my last autonumber was 50. When I went to insert a new record
the new number assigned was 26.

This is a school database and I need this in the event a student return to
school.

Thanks,
 
Stanley said:
I was trying to write an archive for an Access 2002 database. I was able to
copy all related records to another database for a given entity and then
delete them from the original database.

If a user wanted to see old entities they could go to the achive. The
problem I have is that if I wanted to put back an entity with all its
related
records, I couldn't insert the records into my original database.

I ran into a number of problems. For example, I was able to insert record
number 25 and my last autonumber was 50. When I went to insert a new
record
the new number assigned was 26.

This is a school database and I need this in the event a student return to
school.
Click to expand...

I'm not sure that I completely understand your problem but Autonumbers are
for internal indexing purposes and should not mean anything or be visible to
the user. If incremental Autonumbers are used then, once dirtied they will
not be re-used even if the dirty record is discarded without being saved.

Regards,
Keith.
www.keithwilby.com
 
I am trying to archive records so that I can reduce the size of my database.
Also, I need the autonumber number because I use it as an individual's ID.
Thanks,
 
I am trying to archive records so that I can reduce the size of my database.
Click to expand...

Note that an Access database can hold to BILLION bytes of data.
Compact your database, and check the size: is it over 1,800,000,000
bytes? Then it's getting big.

In terms of table size, a properly indexed table with 10,000,000 rows
should be quite usable.

Is your database *really* getting too big...?

John W. Vinson[MVP]
 
John,
My database and tables are no where near those sizes (250meg with 500,000
rows in some tables). I was concerned with corruption and performance mainly.
I was advised that after 100meg I was susceptible to problems.
Thanks
 
Back
Top