Keith, do some reading in the Acc2003 Help files just to be sure. In the earlier versions "no locks" would just protect the whole record, it didn't get down to field level. In most installations it is very rare to get conflicts in a work group.
If you do get lots of collisions, that would mean that you have a large number of users, in which case it would be a smart idea to upsize to SQL Server for that and a whole bunch of other reasons. Brett Keith Browning wrote: > Thank you very much brett. > I have a copy of Office Pro 2003 for every Pc in the business, but > have been > too frightened to install them. > Partly because I have some databases in other businesss that I still feel > responsible for. > > It might have to have to be and all or non desision. > > I will try leaving the locking off. > Will this affect only the whole record or just the field as far as > multiple > users go? > > Cheers > keith > > ----- Original Message ----- > From: "Brett Collings" <[EMAIL PROTECTED] > <mailto:brett.collings012%40msd.govt.nz>> > To: <[email protected] <mailto:ms_access%40yahoogroups.com>> > Sent: Wednesday, August 09, 2006 8:07 AM > 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] > > Yahoo! Groups Links > > __________ NOD32 1.1696 (20060807) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com <http://www.nod32.com> > > -- 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/
