external accdb won't unlock

[taxidev]

I run a job that puts data in an external temp accdb, then I open a form in VBA and set the SourceObject to a query that hits that temp accdb. When I close the form, I set the SourceObject = "", but the laccdb file doesn't go away. If I try to run the job again, it bombs - the temp accdb is already there.



In order to make the lock file go away, I have to completely shut down Access. I have traced the activity of the query and form, but can't find why it is getting hung up.

Does anyone have any idea where this should be getting released?

Thanks,
T

[khalid]

Hi, welcome to AF.Net
laccdb won't go by just setting the SourceObject of the form to "", if your db has the linked tables of external accdb file, it will remain opened unless you completely close the db.

[taxidev]

I don't have any attached tables. My querydef is querying the external accdb file, and that's when the lock file is generated.

[taxidev]

Thanks for looking and pondering this situation. I figured out what to do this morning.
I changed the SQL of the querydef to run against a table in the currentdb rather than the external accdb, requeried theform, then set the source object to nothing. When the form finishes closing, the lock file is gone.

T

[khalid]

Glad to hear that your problem is resolved.