Re: autonumber

Tech-Archive recommends: Fix windows errors by optimizing your registry

It re-seeds from the value you supply to the (optional) third parameter
lngNewStartValue. If you do not supply a value it will reseed the column to
so that it starts with 1. You also will need to set a reference to the
Microsoft ADOX library for this code to function.

Ron W

"Bobcat" <Bobcat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:66B1AE48-B17A-4426-95B9-FBAB31041931@xxxxxxxxxxxxxxxx
Will this reseed the whole table (restart from zero) this is a
TroubleTicket
Database and if a customer call referensing a Ticket# that has been
renumbered it could create problems.

Thx

"Ron Weiner" wrote:

I have some code here http://www.worksrite.com/ReSetAutoNumber.htm that
will
reseed the autonumber seed on your table.

Ron W


"Bobcat" <Bobcat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8F4EA6CC-ACDA-4408-A964-FDE73FDFDB94@xxxxxxxxxxxxxxxx
I have delete all 8 digit records and then did another compact and
repair
to
no avail.

the database is secured and I am the only one with admin access.

should i try to delete the last 4 digit number? 9402 then compact and
repair?

"AccessVandal via AccessMonster.com" wrote:

Maybe you have a code in an event or you had accidentally inserted a
record
into your table with a 8 digit number. The autonumber will auto
increment
with this new number.

Bobcat wrote:
why would the autonumber all of a suden change from a 4 digit number
to
an 8
digit number?

example;
9400
9401
9402
34286622
34296623
Etc

I have used "Compact and Repair Database" to no avail.

--
Please Rate the posting if helps you

Message posted via http://www.accessmonster.com







.

Relevant Pages

  • Re: autonumber
    ... "Ron Weiner" wrote: ... the database is secured and I am the only one with admin access. ... into your table with a 8 digit number. ...
    (microsoft.public.access.formscoding)
  • Re: bound object frame: picture
    ... Ron I'm glad you are making progress with your issue. ... I am a rancher and a retailer, not a database expert. ... If you follow the above steps and your Report still fails then ...
    (microsoft.public.access.forms)
  • Re: cant open shared db
    ... you ned to split your database and get users to run their own ... Select "yes" to repair it. ... local ws, opens the db on the target network share, with the workgroup ... with the repair/compacting process. ...
    (microsoft.public.access.security)
  • Re: cant open shared db
    ... You are not required to split your database to fix this problem now, ... Select "yes" to repair it. ... local ws, opens the db on the target network share, with the workgroup ... with the repair/compacting process. ...
    (microsoft.public.access.security)
  • Re: Check database status.
    ... results to expect from CHECKDB if the database is in need of repair. ... Secondly, if repairs are performed, I want to be able to report to ... >> Ken Varn ...
    (microsoft.public.dotnet.framework.adonet)