Brett, My understanding is that Access 2000 and newer got the record locking fixed so that it only locks a single record. I know that 97 only allowed locking by page. Neil Squires
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Brett Collings Sent: Tuesday, August 08, 2006 2:07 PM To: [email protected] Subject: Re: [ms_access] Sharing problems with split database. 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] [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/
