Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query and SQL (Access03)

    On form open I have the form run an SQL statement that creates a table. From the same form I wanted to have two sub forms populated from the created table. Is there any way to add something to the original SQL statement to free or unlock the created table. Because when I put the subform on the original form I got it a 3211 Runtime error message that we could not lock because table already in use.

    Thank you for your time and input. Fay

    PS welcome back.

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

    Re: Query and SQL (Access03)

    I don't think you can do it this way - you'll always run into timing conflicts between the main form and subforms.
    Instead, I'd create a separate form. When the user opens this form, the table is created. Then, after that, your form with the subforms is opened.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query and SQL (Access03)

    A women can hope. I was guessing that would be the answer. Thanks. Fay

Posting Permissions

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