3218 ("currently locked") error with single user

[aperture]

hello all-

i have a questionnaire database from which i produce a report. the recordset used for the report is generated from several tables and append/update queries. when i try to run the report, i get error description 3218, even without any code specifying a lock type (exclusive, rs, optimistic, pessimistic, etc.), and even when i am using the db alone.

does anyone have any experience with receiving 3218 at strange times? if more info is needed for a helpful response, please let me know.

thank you!

ap

 

[wonderhands]

If you are using DAO, Sometimes the recordset gets in a mess and locks itself. So what i do is before I attempt to do an update. I send any errors to an update_err error_handler.

on error goto err_Update_error


Then in my error handler I call:
DBEngine.Idle dbFreeLocks
then i resume to the update
Resume

This seems to work, most times. You may need to loop inside the error_handler to ensure that this is successful.

heres a LINK TO HELP UNDERSTAND>>>

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A2B5.asp

Hope this helps