I know this question isn't directly related to ASP, but I didn't know 

where else to ask...

I have an autonumber primary key field starting at number 100.. 101.. 

102.. 103.. 104.. 105.. 106.. 107.. then I deleted the next record once. 

Now next record will be 109. Anyway to force it back to 108 ?

I can't remove the primary key because of relations to other tables.



I'm using Microsoft Access 2000.



Thanks.

I believe a compact/repair op will reset the autonumber & reclaim the

deleted one, but that's pretty cumbersome to do every time you need to

delete a rec.  



The advice I've had is to just accept gaps in autonumbers--if you really

need to track every number, you've got to roll your own scheme for

generating/recycling values.



HTH,



-Roy



-----Original Message-----

From: Frode =?UNKNOWN?Q?Str=F8mme?= [mailto:fstroemm@o...]

Sent: Wednesday, April 25, 2001 8:28 AM

To: Access

Subject: [access] Access 2000 primary key





I know this question isn't directly related to ASP, but I didn't know 

where else to ask...

I have an autonumber primary key field starting at number 100.. 101.. 

102.. 103.. 104.. 105.. 106.. 107.. then I deleted the next record once. 

Now next record will be 109. Anyway to force it back to 108 ?

I can't remove the primary key because of relations to other tables.



I'm using Microsoft Access 2000.



Thanks.