Query locked after compacting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kwaldman@gmail.com - 31 Jul 2006 14:19 GMT

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.

Reply to this Message

[MVP] S.Clark - 31 Jul 2006 17:40 GMT

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.

Signature

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

>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
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message