Error 2486: You can't carry out this action

[Steve]

I am getting this error, #2486, "You can't carry out this action at the
present time" when trying to close forms or go to other forms after I
update a number of records in my database via code.
I can't tell exactly what is locking it up.

Any ideas as to what might cause this?

Steve

 

[Guest]

Can you close the forms during the update of data?

- Raoul

 

[Steve]

The actual update takes just a few seconds. It is _after_ that that the
forms/buttons are locked. I have to close Access and open it again in
order to move to the next task. Inconvenient, to say the least...

Steve

 

[Guest]

Can you give us the code please?

- Raoul

The actual update takes just a few seconds. It is _after_ that that the
forms/buttons are locked. I have to close Access and open it again in
order to move to the next task. Inconvenient, to say the least...

Steve

 

[Guest]

I was going thru the same problem.

In my case I had a form/subform structure. I have 2 fields in my linkfields
(Fiscal year and department) and I also have a third field (business) which
is optional. When selected I was filtering using: Child1.form.filter =
"business = ""My Business"""

After changing the filtering options a few times, I was getting the error
2486.

I fixed it by changing dynamically the RecordSource of the subform when I
select the third filter, as below and keeping the LinkFields:

Child1.Form.RecordSource = "SELECT * FROM [BUDGET DATA]" & _
iif(ComboBusiness = "- ALL", "", " WHERE Business =
""" & ComboBusiness & """")

I hope it helps

Take care

Mauricio Silva