Re: 2 users in 1 record



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)
  • 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)
  • 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)
  • VIDEO Fallujah: The Hidden Massacre VIDEO
    ... WARNING: This video contains graphic and possibly disturbing footage. ... Prev by Date: ...
    (soc.culture.scottish)
  • Re: Power Options Missing
    ... Properties I don't have a 'Power Management' tab. ... There has to be a Registry setting for this. ... WARNING: Due to Presidential Executive Orders, ...
    (microsoft.public.windows.mediacenter)