Database fails to open

[cc]

When I open an access 2002 database, then close the
database. When I try to open any database files later in
the day, they will not open until I "end process"
MSACCESS.exe. The pc is running win xp pro and office xp.

 

[losmac]

How You do that?

If You use OLE Automation, for example:
Set AccApp = CreateObject("Access.Application")
You must to kill this object after all operation
Set AccApp = Nothing
The same way is need when You OpenDatabase
Set dbs = OpenDataBase("path")
with dbs
'some operations
.Close
end with
Set dbs = Nothing

I hope, You understand what I mean...
losmac