Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unanswered: Multi-User Record

    Hi all.
    I have 2 questions to try avoid multi-users errors.
    (The problem to me is only editing records)

    1- It is possible to check, by vba, if a record is being edited in back-end? (to avoid the opening of the form)

    2- It is possible to know if form is loaded in others front end's (user2 and user3) from user1? (if no answer for question 1)

    Ty and sorry my english.


  2. #2
    Join Date
    Jan 2007
    California, USA
    What I have done is to create a table that will be used for just this purpose. When I retrieve a record for editing, I place the table name, record key, and date retrieved into this "locking" table. This way, before retrieving a record for editing, I can check this "locking" table by table name, and record key to see if this record is "checked out" for editing. If found, I check the date of the "lock". If it is more than 1 hour old I ignore it, post the new informaiton about the new person wanting to "lock" this record, then proceed with posting this record on the workstation ready to be edited. The reason I check the time, is that if the time is more than an hour old, I assume that something happened to the previous process, and the record really is available for editing.
    This system has been in production for over 8 years with no problems.

  3. #3
    Join Date
    Nov 2003

    Thumbs up

    Very Nice Idea!!!!

    Much Ty


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts