Main Page 
PC Review
Forums
Newsgroups
Microsoft Word
Microsoft Frontpage
What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
Forums
Newsgroups
Microsoft Word
Microsoft Frontpage
What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
 |
What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages |
|
|
Thread Tools | Rate Thread |
05-11-2004, 02:16 PM
|
#1 |
|
Guest
Posts: n/a
|
What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
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 |
|
|
05-11-2004, 02:24 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
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) http://www.ycoln-resources.com FrontPage Resources, WebCircle, MS KB Quick Links, etc. ============================================== To assist you in getting the best answers for FrontPage support see: http://www.net-sites.com/sitebuilder/newsgroups.asp "Dave" <davekstl@charter.net> wrote in message news:10on2qq7o8csp76@corp.supernews.com... >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 > |
|
|
|
05-11-2004, 02:39 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
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" <tarowe@mvps.org> wrote in message news:%23dag6M0wEHA.2876@TK2MSFTNGP12.phx.gbl... > 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) > http://www.ycoln-resources.com > FrontPage Resources, WebCircle, MS KB Quick Links, etc. > ============================================== > To assist you in getting the best answers for FrontPage support see: > http://www.net-sites.com/sitebuilder/newsgroups.asp > > "Dave" <davekstl@charter.net> wrote in message > news:10on2qq7o8csp76@corp.supernews.com... >>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 >> > > |
|
|
|
05-11-2004, 02:47 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
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) http://www.ycoln-resources.com FrontPage Resources, WebCircle, MS KB Quick Links, etc. ============================================== To assist you in getting the best answers for FrontPage support see: http://www.net-sites.com/sitebuilder/newsgroups.asp "Dave" <davekstl@charter.net> wrote in message news:10on44o92qru713@corp.supernews.com... > 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" <tarowe@mvps.org> wrote in message > news:%23dag6M0wEHA.2876@TK2MSFTNGP12.phx.gbl... >> 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) >> http://www.ycoln-resources.com >> FrontPage Resources, WebCircle, MS KB Quick Links, etc. >> ============================================== >> To assist you in getting the best answers for FrontPage support see: >> http://www.net-sites.com/sitebuilder/newsgroups.asp >> >> "Dave" <davekstl@charter.net> wrote in message news:10on2qq7o8csp76@corp.supernews.com... >>>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 >>> >> >> > > |
|
|
|
05-11-2004, 03:02 PM
|
#5 |
|
Guest
Posts: n/a
|
Re: What events would cause access autonumberto be missing sequential numbers when there are no delete asp pages
Thanks
"Thomas A. Rowe" <tarowe@mvps.org> wrote in message news:%23kbwXZ0wEHA.3096@TK2MSFTNGP14.phx.gbl... >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) > http://www.ycoln-resources.com > FrontPage Resources, WebCircle, MS KB Quick Links, etc. > ============================================== > To assist you in getting the best answers for FrontPage support see: > http://www.net-sites.com/sitebuilder/newsgroups.asp > > "Dave" <davekstl@charter.net> wrote in message > news:10on44o92qru713@corp.supernews.com... >> 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" <tarowe@mvps.org> wrote in message >> news:%23dag6M0wEHA.2876@TK2MSFTNGP12.phx.gbl... >>> 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) >>> http://www.ycoln-resources.com >>> FrontPage Resources, WebCircle, MS KB Quick Links, etc. >>> ============================================== >>> To assist you in getting the best answers for FrontPage support see: >>> http://www.net-sites.com/sitebuilder/newsgroups.asp >>> >>> "Dave" <davekstl@charter.net> wrote in message >>> news:10on2qq7o8csp76@corp.supernews.com... >>>>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 >>>> >>> >>> >> >> > > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
