Autonumber on split database

[Brian Carlson]

If I use an autonumber field with a split databse, is it possible that two
users will create records with the same autonumber? Thanks in advance.

Brian

 

[Douglas J. Steele]

No, it's not.

The AutoNumber value gets assigned as soon as the user "dirties" the record
(whether or not they actually save it).

 

[Stefan Hoffmann]

hi Brian,

If I use an autonumber field with a split databse, is it possible that two
users will create records with the same autonumber? Thanks in advance.

AutoNumbers are per table and tables cannot be split between databases.
So the answer is: No.



mfG
--> stefan <--

 

[Tom Wickerath]

Hi Brian,

It is possible, but the only time I've seen it is if one or more PCs have a
much earlier version of the JET Service Pack (I think it was SP-3 and lower).

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

In particular, follow the three links:

Verify that the latest operating system service pack is installed
Verify that the latest Microsoft Jet service pack is installed and
Verify that the latest service pack for your version of Office is
installed

Also recommended: Install the latest version of MDAC (Microsoft Data Access
Components)
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Wickerath]

Oh, and to clarify....in this case the second attempt to create the same
autonumber value would trigger an error; the record will not be added.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Brian Carlson]

Follow-up: This would mean that some numbers may not end being used in the
Autonumber sequence. Thanks

 

[Douglas J. Steele]

That's correct. AutoNumber fields are not guaranteed not to have gaps.

 

[David W. Fenton]

AutoNumber fields are not guaranteed not to have gaps.

This should be obvious if you take the time to understand them
correctly.

Autonumbers are not record numbers -- they are only a special form
of default value. That is why you can append a value to an
Autonumber field in an APPEND query, because, just like any other
field with a default value, you can append a value other than the
default (as long as it doesn't violate the index).