Re: 2 users in 1 record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Tue, 29 Nov 2005 16:24:44 -0600, bil <asdf@xxxxxx> wrote:

>we keep having problems with 2 users trying to access the same record at
>the same time (from their desktops)is there a way to have a warning appear
>as soon as the 2nd user trys to access the record or better still have the
>system lock him out with a message?
>
>now the 2nd user doesn't know of the problem until he tries to save his
>work - and that's when he finds out he can't because of the other user in
>the record.
>
>tks

In Tools... Options, set the Default Record Locking on the Advanced
tab to "Edited Record".

John W. Vinson[MVP]
.



Relevant Pages

  • What is the VBA code to delete a sheet without warning message?
    ... I have the following code to delete a tab: ... I get the standard "You may lose data" warning ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: pdf file not registered
    ... I highlight the phrase I want to link with the left mouse button. ... On the Mouse Click tab I ... Your warning about spaces in the files makes sense (although it hasn’t been ... the pdf file opens up fine. ...
    (microsoft.public.powerpoint)
  • Re: How to know if anyone using an access sql application is in a reco
    ... A word of warning. ... I have attempted to use edited record for record locking. ... This class of lock is somewhat misleading, ... "Edited Record lock" we were continually getting the lockout situation ...
    (microsoft.public.access.formscoding)
  • Re: Question about Deprecated Functions
    ... if the issue was around the questionable "deprecation" warning or of it was ... private setting where the discussion took place. ... Regards, ... Prev by Date: ...
    (microsoft.public.vc.language)
  • Make assign illegal for class
    ... and generate a warning? ... constructor but I have no idea about generating a compile error inside it). ... - Mark Randall ... Prev by Date: ...
    (microsoft.public.vc.language)