DB closes but Access keeps running!

[ipr1]

I run several databases daily - after running two of them (at different times), the database itself closes but the Access program stays open. In order to close that program, I have to close it out using the Task Manager.

Any suggested solutions? Thanks (as always) for your assistance.

Bob

 

[Bat17]

I would check and make sure that all objects set are released.

Set dbs = CurrentDb
Set rstXLS = dbs.OpenRecordset("tblXLfiles")

..........

Set rstXLS = Nothing
Set dbs = Nothing

HTH

Peter