Record locking SQL BE Access FE Crossh 27.09.2006 12:54:02 I have an Access database front end which is linked to a Sql Server back end which contains all the tables. In the Advanced Options, I set the Default Record Locking to Edited Record. On the Form I set the Record Locks property to Edited Record. However, multiple users can still open up the form with the same record on it and edit it simultaneously. How can I stop multiple users from opening up the same record at the same time?

Re: Record locking SQL BE Access FE "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 27.09.2006 15:15:49 The Default Record Locking option works only when Access is the backend database, not with SQL-Server. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Crossh" <Crossh[ at ]discussions.microsoft.com> wrote in message news:DF401376-E5A0-4565-9B84-2A72C108EC1E[ at ]microsoft.com... [Quoted Text] >I have an Access database front end which is linked to a Sql Server back >end > which contains all the tables. > > In the Advanced Options, I set the Default Record Locking to Edited > Record. > > On the Form I set the Record Locks property to Edited Record. However, > multiple users can still open up the form with the same record on it and > edit > it simultaneously. How can I stop multiple users from opening up the same > record at the same time? >