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

    Locked table (Access03)

    I have a button that makes a table and also appends records to that table. Then I have a subform created from that table on the same form as the mentioned button. When the button is pressed I get the message that the table is locked since it is already in use. What is the best work around for this? I thought about putting the button on the registration form, but that is only one way of registering people. You can also register people from the form that the button is currently on. Thank you. Fay

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Locked table (Access03)

    I assume that the problem arises when you want to delete the existing table - as long as the subform based on the table is open, you cannot delete it. Why is it necessary to create a table? Perhaps you could keep the table, and delete existing records, then append new records.

Posting Permissions

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