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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    Populate field on linked form from main form

    Guest, Feb 11, 2005, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    293
    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:
    365
    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:
    501
    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:
    404
    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:
    195
    Guest
    Jul 8, 2005
  6. Tom K via AccessMonster.com

    Main form with two subforms on it and linked to it

    Tom K via AccessMonster.com, Dec 11, 2005, in forum: Microsoft Access Forms
    Replies:
    3
    Views:
    335
  7. Guest

    RE: Subfrom linked to main form and computed value

    Guest, Dec 28, 2005, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    232
    Guest
    Dec 28, 2005
  8. Replies:
    1
    Views:
    229
    kingston via AccessMonster.com
    Nov 29, 2006
Loading...