Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Database over a network (Access 97)

    I would like to know what the preferred solution is to updaing an Access database over a network. I have been told that you should save the record in the after update event of each control on a form. This releases the page being referenced so i ws told.
    The same logic is used when SQL is the back end.

    Your thoughts are valued.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database over a network (Access 97)

    But saving the record in the After Update event of each control makes undoing changes more difficult - normally, pressing Esc will undo changes in the active control (if any), then pressing Esc again will undo all changes to the current record. But if the record has already been saved, the latter will not work. So I wouldn't use this method. If you really want to avoid record-locking problems as much as possible, you could work with unbound forms and only save a record on demand (using a command button).

    BTW Access 97 is getting a bit long in the tooth. Later versions have better record-locking options.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Database over a network (Access 97)

    I appreciate that Hans.

Posting Permissions

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