weird things when sharing

[darkproject]

Hi all,

I am trying to share a database with other people on the network. This is successful so far. However there has been a couple of odd outcomes and i was wondering if i could get any reasoning behind why what has happened, happened.

First, when all people sign out and stop using it, and i look up the data. The autonumbering is all out of sink. i.e. not 1, 2, 3, 4, 5, ....n

But 6, 2, 7, 8, 9, 10, 13, 11, 12, how can i get it to refresh it self. or is it the order it was entered in matter.

Secondly, there were multiple copies of one partiuclar record so like

1 Jane Smith a b c d e f g

2 Gary Anderton f g h j k l l

3 Paul Stewert df df df fd fd

1 Jane Smith a b c d e f g

5 Steven Chappell r g t h yj

So number 4, was missed out and replaced with another data entry.


Anyone know what is going on at all? All help would be greatly appreciated..

Many thanks

Darren

 

[jeremie_ingram]

Is this a front end / back end situation? If so, this shouldnt happen, and if the autonumber is set asa the primary key, it will not allow duplicates. Even if it is not the primary key, you can still stipulate no dupps allowed and it should stop doing that.

 

[neileg]

When you use autonumber this does not ensure continuous numbering. If one user starts entering a record, Access provides an autonumber, the next user gets the next number for their new record. If the first user abandons their record, the autonumber is also abandoned, but the second user retains their number. Thus you will always get gaps. This is not a bug!

 

[darkproject]

Yes it is a FE / BE situation, as it was advise given to me earlier when i was about to share the DB.

The autonumbering logic system is not really a big deal, and i understand why there could be gaps.

However the duplication of another record is a cause for concern.


Thank you very much for responding, i'll go back and see if the settings are incorrect.

Cheers

Darren

 

[darkproject]

hmmm

Hmmm well it was PK until i split it for FE/BE but now it looks though the autonumber has no PK.


Darren