Table opened exclusively by form, can't run Command Buttons or Store Procedures

G

Guest

I have a form that contains a series of Command Bottons, which calls a
series of Stored Procedures. Under each Command Button, I have a bound text
box that calles from the Actions TBL Button1StartRun, Button1EndRun, and
Button1LastRun. As the Store Procedures coding updates the appropratiate
table fields.

Well all was working fine, until I created the bound text boxes. The form
populates properly when opened, however when I click one of the Command
Buttins I receive: The table 'Actions' is already opened exclusively by
another user, or it is already open through the user interface and cannot be
manipulated programatically.

Of course, it is the User Interface that has opened the table. Where do I
go to start correcting this?

Thanks
 
G

Guest

Found it. Under Form Properties, Record Locks. Default was All Records.
Switched to No Records, as this is appropriate for this particular form.
And Wha La, All Fixed.
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Top