access autonumber change

R

Rebecca Riordan

You can append a record with the value one-less that the one you're seeking
using an append query, but if you care what the value is, you _shouldn't_ be
using an autonumber. They're not guaranteed to be consecutive, or even
sensible, only unique (and even that's disputed). If you care what the
value is, roll your own. There are a bunch of samples on
www.mvps.org/msaccess.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Autonumber field in Excel that behaves the same as Access 0
convert a number to an autonumber 4
autonumbers 3
Autonumber field with semi-static text? 4
autonumber queestion 3
How do I change the starting value of autonumber (Access 2007)? 2
change the starting vaule for an autonumber field access 2007 5

Top