Error 3218 BrianP 11/21/2008 4:07:02 PM I have a FE/BE multiuser database. BE is on the network, a copy of the FE is on each users PC. The database options are set for default no locks with record level locking checked. I have a form in the FE for adding records to a table linked from the BE. The record source for the form is the linked table, not a query. I have set the form properties to no locks, to not allow edits or deletes, and for data entry only to make sure that users only enter new records. Each user makes about 40-50 enties per day but they leave the form open all day for convenience. Usually there will be 20-25 users with the form open at any one time. Frequently the users report getting a "3218 Could not update currently locked" error. Since each user is only working on their own new record, I don't understand what would cause this error. I am just beginning with mutli-user databases so it may be something simple. Any help anyone can provide is appreciated. -- BrianP

Re: Error 3218 "bhicks11 via AccessMonster.com" <u44327[ at ]uwe> 11/21/2008 8:18:53 PM In the database properties, is the open mode SHARED? Also, I set my forms Record Locks to Edited Record. Bonnie http://www.dataplus-svc.com BrianP wrote: [Quoted Text] >I have a FE/BE multiuser database. BE is on the network, a copy of the FE is >on each users PC. The database options are set for default no locks with >record level locking checked. I have a form in the FE for adding records to >a table linked from the BE. The record source for the form is the linked >table, not a query. I have set the form properties to no locks, to not allow >edits or deletes, and for data entry only to make sure that users only enter >new records. Each user makes about 40-50 enties per day but they leave the >form open all day for convenience. Usually there will be 20-25 users with >the form open at any one time. Frequently the users report getting a "3218 >Could not update currently locked" error. Since each user is only working on >their own new record, I don't understand what would cause this error. I am >just beginning with mutli-user databases so it may be something simple. Any >help anyone can provide is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200811/1

Re: Error 3218 BrianP 11/24/2008 2:08:01 PM The Open Mode is set to Shared. I will try the Record Locks setting to see if that helps. -- BrianP "bhicks11 via AccessMonster.com" wrote: [Quoted Text] > In the database properties, is the open mode SHARED? Also, I set my forms > Record Locks to Edited Record. > > Bonnie > http://www.dataplus-svc.com > > BrianP wrote: > >I have a FE/BE multiuser database. BE is on the network, a copy of the FE is > >on each users PC. The database options are set for default no locks with > >record level locking checked. I have a form in the FE for adding records to > >a table linked from the BE. The record source for the form is the linked > >table, not a query. I have set the form properties to no locks, to not allow > >edits or deletes, and for data entry only to make sure that users only enter > >new records. Each user makes about 40-50 enties per day but they leave the > >form open all day for convenience. Usually there will be 20-25 users with > >the form open at any one time. Frequently the users report getting a "3218 > >Could not update currently locked" error. Since each user is only working on > >their own new record, I don't understand what would cause this error. I am > >just beginning with mutli-user databases so it may be something simple. Any > >help anyone can provide is appreciated. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200811/1 > >

Re: Error 3218 BrianP 12/3/2008 2:40:01 PM Changing the Record Locks setting to Edited Record did not help. Also, during the US holiday last week when most of the users were not working, the incidence of errors was greatly reduced. Any other ideas much appreciated. -- BrianP "BrianP" wrote: [Quoted Text] > The Open Mode is set to Shared. I will try the Record Locks setting to see > if that helps. > -- > BrianP > > "bhicks11 via AccessMonster.com" wrote: > > > In the database properties, is the open mode SHARED? Also, I set my forms > > Record Locks to Edited Record. > > > > Bonnie > > http://www.dataplus-svc.com > > > > BrianP wrote: > > >I have a FE/BE multiuser database. BE is on the network, a copy of the FE is > > >on each users PC. The database options are set for default no locks with > > >record level locking checked. I have a form in the FE for adding records to > > >a table linked from the BE. The record source for the form is the linked > > >table, not a query. I have set the form properties to no locks, to not allow > > >edits or deletes, and for data entry only to make sure that users only enter > > >new records. Each user makes about 40-50 enties per day but they leave the > > >form open all day for convenience. Usually there will be 20-25 users with > > >the form open at any one time. Frequently the users report getting a "3218 > > >Could not update currently locked" error. Since each user is only working on > > >their own new record, I don't understand what would cause this error. I am > > >just beginning with mutli-user databases so it may be something simple. Any > > >help anyone can provide is appreciated. > > > > -- > > Message posted via AccessMonster.com > > http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200811/1 > > > >

Re: Error 3218 "bhicks11 via AccessMonster.com" <u44327[ at ]uwe> 12/3/2008 4:07:16 PM Do you have any events or code running that might be locking up? Bonnie http://www.dataplus-svc.com BrianP wrote: [Quoted Text] >Changing the Record Locks setting to Edited Record did not help. Also, >during the US holiday last week when most of the users were not working, the >incidence of errors was greatly reduced. Any other ideas much appreciated. >> The Open Mode is set to Shared. I will try the Record Locks setting to see >> if that helps. >[quoted text clipped - 18 lines] >> > >just beginning with mutli-user databases so it may be something simple. Any >> > >help anyone can provide is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200812/1

Re: Error 3218 "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 12/4/2008 3:45:46 AM BrianP <BrianP[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I have a FE/BE multiuser database. BE is on the network, a copy of the FE is >on each users PC. The database options are set for default no locks with >record level locking checked. I have a form in the FE for adding records to >a table linked from the BE. The record source for the form is the linked >table, not a query. I have set the form properties to no locks, to not allow >edits or deletes, and for data entry only to make sure that users only enter >new records. Each user makes about 40-50 enties per day but they leave the >form open all day for convenience. Usually there will be 20-25 users with >the form open at any one time. Frequently the users report getting a "3218 >Could not update currently locked" error. Since each user is only working on >their own new record, I don't understand what would cause this error. I am >just beginning with mutli-user databases so it may be something simple. Any >help anyone can provide is appreciated. I suspect the problem is because page locking is happening rather than record locking. I'm not familiar with all the details but my recollection is that there are a number of fairly strict requirements to get record locking working. Furthermore the first work station opening the MDB sets that option for everyone else accessing the MDB until everyone has completed accessing the BE MDB. I'd suggest looking up record locking in Access help and also on the Microsoft Knowledge Base at support.microsoft.com. Note that in Access multiple records can exist in a page. However Jet 4.0 seems to add new or updated records into their own page and compacting then moves multiple records into one page. However this is only what I've sort've picked up over time so don't trust what I say. I base this observation partially on how Jet 4.0/A2000 data MDBs would bloat significantly faster than Jet 3.5/A97 MDBs would. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Error 3218 "bhicks11 via AccessMonster.com" <u44327[ at ]uwe> 12/4/2008 12:36:35 PM You just jogged my memory Tony. We had a problem with "opportunistic locking" (OPLOCK) before on a network. We turned off OPLOCKS at each workstation with some modifications to the registry. Here is a link to some info: http://www.granite.ab.ca/access/corruption/causesoplocks.htm It did the trick for us, I think its the ticket. Bonnie http://www.dataplus-svc.com Tony Toews [MVP] wrote: [Quoted Text] >>I have a FE/BE multiuser database. BE is on the network, a copy of the FE is >>on each users PC. The database options are set for default no locks with >[quoted text clipped - 9 lines] >>just beginning with mutli-user databases so it may be something simple. Any >>help anyone can provide is appreciated. > >I suspect the problem is because page locking is happening rather than >record locking. I'm not familiar with all the details but my >recollection is that there are a number of fairly strict requirements >to get record locking working. Furthermore the first work station >opening the MDB sets that option for everyone else accessing the MDB >until everyone has completed accessing the BE MDB. > >I'd suggest looking up record locking in Access help and also on the >Microsoft Knowledge Base at support.microsoft.com. > >Note that in Access multiple records can exist in a page. > >However Jet 4.0 seems to add new or updated records into their own >page and compacting then moves multiple records into one page. >However this is only what I've sort've picked up over time so don't >trust what I say. I base this observation partially on how Jet >4.0/A2000 data MDBs would bloat significantly faster than Jet 3.5/A97 >MDBs would. > >Tony -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200812/1

Re: Error 3218 "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 12/7/2008 2:13:36 AM "bhicks11 via AccessMonster.com" <u44327[ at ]uwe> wrote: [Quoted Text] >You just jogged my memory Tony. We had a problem with "opportunistic >locking" (OPLOCK) before on a network. We turned off OPLOCKS at each >workstation with some modifications to the registry. Here is a link to some >info: > >http://www.granite.ab.ca/access/corruption/causesoplocks.htm Yes, that's my website. >It did the trick for us, I think its the ticket. This would've fixed up the OpLocks problem but I don't think this will fix your problem. OTOH it can't hurt to double check. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/