Optomistic Locking in adp

Discussion in 'Microsoft Access External Data' started by Guest, Jan 23, 2004.

  1. Guest

    Guest Guest

    Hi
    I have an access project (.adp) running under Access Xp that has a form based on a view that includes a join between a tbale and it parent. The form displays fields from the parent and allows updates to the child row only.

    If more than one user updtaes the child row I get a conflict error asking to 'save record', 'copy to clipboard', or 'drop changes'. However, the 'save record' option does not work, it just keeps redisplaying the same conflict error.

    The child table is specified as the unique table and i have a resync command select * from view where childkey = ?.

    This seems to work Ok for single table views but not for multi table views.

    How to get the save record options to actually save the record ?

    Regards
    Dave
     
    Guest, Jan 23, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matt Weaver

    ADP access to a MDB tables

    Matt Weaver, Sep 10, 2003, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    217
    Joe Fallon
    Sep 11, 2003
  2. PBigOS

    Hot to Link Access.adp with ADS (Advantage Database Server)

    PBigOS, Dec 15, 2003, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    266
    PBigOS
    Dec 15, 2003
  3. Guest

    adp file in a peer-to-peer network

    Guest, Jan 23, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    193
    Guest
    Jan 23, 2004
  4. Guest

    Linking Project.adp to different SQL Server Database

    Guest, Jan 31, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    206
    Mary Chipman
    Jan 31, 2004
  5. alan

    access2003/adp & sql server2000 - add/edit data

    alan, Feb 26, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    199
Loading...

Share This Page