Autonumber on split database

  • Thread starter Thread starter Brian Carlson
  • Start date Start date
B

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
 
No, it's not.

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

Brian said:
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.
Click to expand...
AutoNumbers are per table and tables cannot be split between databases.
So the answer is: No.



mfG
--> stefan <--
 
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
__________________________________________
 
Follow-up: This would mean that some numbers may not end being used in the
Autonumber sequence. Thanks
 
AutoNumber fields are not guaranteed not to have gaps.
Click to expand...

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).
 
Back
Top