Opening and Closing Access

[David Tunstall]

Please Help,

I have a database that opens and closes fine most of the
time. I have a shortcut on the desktop to access the
database. Sometimes after I have closed the database and I
click back on the shortcut to open it nothing happens.
When I look at the task manager under processes, access is
still running as MSACCESS.EXE even though I have exited
the database

So I have to end this process and then it will let me in.

Any clues.

Thanks
David

 

[RobFMS]

In your VBA code, make sure you close all objects that you open.

For example, if you open a Recordset in a function/procedure, then make sure
you close it at the end.

Private Sub Acme()
:
Set rst as DAO.Recordset
:
:
rst.Close
Set rst = Nothing

End Sub


Other objects to check for are Databases and QueryDefs

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-