N
Newby99
I have a fom that's open and the record source of the form (table) is what I
am trying to apply an action query to programatically (trying to drop a
column). But I get the message that the recordset is locked by another
person or process. I can't seem to get this to work through the current
form. I have created a work around by having this main form close and using
another form to run the action query, then returning to the main form, but
there must be a way that I can do it without having to use an extra form?
through VBA I have tried - closing the form, closing the form and changing
the recordsource temporarily (and saving the changes from the design view),
closing the form then opening another form and making sure the new form has
focus. But I can't find anyway to free up the table so that I can apply this
drop column command.
I'm sure the answer to this is simple, but I havent' been able to figure it
out. Any ideas would be greatful.
am trying to apply an action query to programatically (trying to drop a
column). But I get the message that the recordset is locked by another
person or process. I can't seem to get this to work through the current
form. I have created a work around by having this main form close and using
another form to run the action query, then returning to the main form, but
there must be a way that I can do it without having to use an extra form?
through VBA I have tried - closing the form, closing the form and changing
the recordsource temporarily (and saving the changes from the design view),
closing the form then opening another form and making sure the new form has
focus. But I can't find anyway to free up the table so that I can apply this
drop column command.
I'm sure the answer to this is simple, but I havent' been able to figure it
out. Any ideas would be greatful.