Query locked after compacting

[kwaldman]

I have a database of about 7000 records, 8 fields, that contains a fair
amount of VBA. The database started to get a little large, so I tried
to compact and repair it. After it compacts and repairs, when I try to
run the VBA, which simply runs a query, then opens a form that displays
the results of the query, I get this message:

Run-time error '3218':
Could not update; currently locked.

Any ideas on how to fix this?

Thanks.

 

[[MVP] S.Clark]

Do the 8 fields contain VBA code? How are you able to run it?

If the code is just code(not in a table) try to decompile and recompile.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html