What events would cause access autonumberto be missing sequential numbers when there are no delet

[Dave]

I use Access as the db for my Frontpage asp pages.

The field is set not to duplictae and be indexed and this field REGID is a
the primary key.

There have been errors on the insert page.

The question is when inserting a record and it errors, does autonumber skip
that number?

Thanks

Dave

 

[Thomas A. Rowe]

For every record written to the database the autonumber will assign the next number. If the insert
fails and no record is written, then the next successful record with get the number.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Dave]

So if an error would not cause a number to disappear, can you think of a
reason that a number would be missing, other than deleted.

I have no pages in place to delete records.

I am trying to figure out how to chase this.

Thanks

 

[Thomas A. Rowe]

I can't think of any reason for this, but you might want to post to the Access newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Dave]

Thanks

I can't think of any reason for this, but you might want to post to the
Access newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================