Cannot update main table if linked table is open

Discussion in 'Microsoft Access Forms' started by Guest, Mar 10, 2006.

  1. Guest

    Guest Guest

    I have a split database with a form (in the front-end db) used for searching
    a table that is linked to the main table in the back-end db. If the form is
    open when I attempt to update the main table I get the following error
    message: "You tried to lock table (tablename) while opening it but the table
    cannot be locked because it is currently in use".

    The form Record Locks property is set to "No Locks" and the Recordset type
    is "Snapshot". The default record locking for both dbs is set to No Locks.

    How can I set this up to be able to update records on the main table if the
    form is open?
     
    Guest, Mar 10, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Change the recordset type to Dynaset

    --
    jl5000



    "btee" wrote:

    > I have a split database with a form (in the front-end db) used for searching
    > a table that is linked to the main table in the back-end db. If the form is
    > open when I attempt to update the main table I get the following error
    > message: "You tried to lock table (tablename) while opening it but the table
    > cannot be locked because it is currently in use".
    >
    > The form Record Locks property is set to "No Locks" and the Recordset type
    > is "Snapshot". The default record locking for both dbs is set to No Locks.
    >
    > How can I set this up to be able to update records on the main table if the
    > form is open?
     
    Guest, Mar 10, 2006
    #2
    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. Guest

    Populate field on linked form from main form

    Guest, Feb 11, 2005, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    225
    Guest
    Mar 29, 2007
  2. mkiew via AccessMonster.com

    after update linked field on main form, the data on subform got lost

    mkiew via AccessMonster.com, Apr 18, 2005, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    243
    Rick B
    Apr 18, 2005
  3. mkiew via AccessMonster.com

    subform won't get updated when linked field on main form is updated

    mkiew via AccessMonster.com, Apr 19, 2005, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    362
    John Vinson
    Apr 20, 2005
  4. Dave Elliott

    Open Form Linked to Main Form?

    Dave Elliott, May 28, 2005, in forum: Microsoft Access Forms
    Replies:
    14
    Views:
    268
    Dave Elliott
    May 31, 2005
  5. Guest

    open main form using linked form criteria

    Guest, Jul 8, 2005, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    123
    Guest
    Jul 8, 2005
Loading...

Share This Page