Access will not close 1

[trudye10]

My program completes processing but Access will not close. I have added a 'QUIT' and also a 'application.quit' but that did not eliminate the problem. The ldb file also remains open.

Does anyone have any idea how to get Access to clost normally?

Trudye

 

[trudye10]

OBTW the program closes just fine. But I have to use the Task Manager to close Access.

 

[JerryKlmns]

If you

Dim objAccess As Access.Application
Set objAccess = New Access.Application

--or
Dim objAccess As Object
Set objAccess = CreateObject("Access.Application")

then
objAccess.Quit
Set objAccess = Nothing

Should work

But

If you open a connection (cnn) to your database
then use

cnn.Close
Set cnn = Nothign

 

[trudye10]

Jerry, sorry it took me so long to get back to you, but thank you so much for responding. I'll try your suggestion immediately.

Trudye

 

[trudye10]

Hi Jerry, Thanks for responding.

I tried the suggested code this morining. I put a stop in the pgm so I could step thru the code. It did not close the program.

Thanx again,
Trudye

 

[JerryKlmns]

Which one suggested code?
Then maybe you should post how you start-open your access from your program.

If no connection is open, nor a recordset and they have been destroyed before going out of scope, or you destroy the automation object and access is still running then .... I have no clue.

BTW you do have read+write+execute+delete rights on that folder plus the mdb and mdw files.

 

[trudye10]

The Access module is started via a scheduler like all the other Access modules. The scheduler opens the module and executes a macro when it is done it closes the module. The quirky part is that it closes properly on other PC's.

Thanks for responding,
Trudye