Okay Keith your problem is that you're using record locking - true!
If you read up about record-locking in Help it will explain that Access
locks a "page" of records, not just one record as you would think. A
"page" is an undefined value that varies with a whole bunch of variables
that I don't understand and maybe are only known to the Access
engineers. Apparently page locking can lock at least 50 records and
sometimes more.
The answer is to set everything to "No Locking". Then when two users
actually bump into each other on a record, one of them has to abandon
their entry until it's clear
Some of this has been addressed from XP onwards (I think).
Brett
Keith Browning wrote:
> Hi all,
>
> I'm having a problem with my first split database.
> If more than one user tries to input data in records not necesarily being
> used by someone else, they find they can't.
> The other user has to exit the program.
>
> Tools, Options, Advanced, has these settings.
>
> Default open mode = shared
> Default record locking = Edited record.
> Open databases using record-level locking is "ticked".
>
> I'm using Access 2000 (9.0.6926 SP-3)
>
> I don't have trouble with other similar databases that are not split
> but are
> multi user.
> The data only is on a commonly mapped server.
> Each user is using a copy of the front end installed on their PC.
>
> Any clues would be really appreciated.
> Best regards.
> Keith Browning
>
>
--
Brett Collings
Strengthening Families Administrator
D2D 46422
DDI (04) 916 3422
-------------------------------
This email message and any attachment(s) is intended only for the
person(s) or entity(entities) to whom it is addressed. The
information it contains may be classified as IN CONFIDENCE and may be
legally privileged. If you are not the intended recipient any use,
disclosure or copying of the message or attachment(s) is strictly
prohibited. If you have received this message in error please
notify us immediately and destroy it and any attachment(s).
Thank you. The Ministry of Social Development accepts no
responsibility for changes made to this message or to any
attachment(s) after transmission from the Ministry.
-------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
