MSAccess.exe not closing

[Guest]

Hello
Recently I posted a question about MSAcces.exe not closing completely when it is closed. A reply suggested I check my references.

I am using office xp (sp2) running on windows xp home edition and professional (two different computers).
I have 256 ram.
The database has a front end (that doesn’t close) and a back end.
All ‘dbs’ and ‘rst’ are closed now.
For years this was not done (I didn’t know any better) and never had this problem before.

I’ve worked through many combinations and there are four things that may offer clues.

I’ve compacted the database while it was opened with this code. Could it cause a problem?

Private Sub compact_Click()

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Sub

I can open the database and closed it completely if one of the forms doesn’t have conditional formatting on a certain field.
If I put the conditional formatting in MSAcces.exe doesn’t close.

When I save any object, I’m asked if I want to save many open forms even if I never worked with them.

I have five references:
Visual Basic For Applications
Microsoft 10.0 Object Library
Ole Automation
Microsoft dao 3.6 object library
Microsoft activex data objects 2.7 library

If they are in this order, the program will open fine but MSAcces.exe will not close

If Microsoft activex data objects 2.7 library is placed before Microsoft dao 3.6 object library
The program opens but gives a type mismatch error message (it’s trying to open a recordset).
Click on end and the program goes to the main menu. When access is closed MSAcces.exe closes also.



Thanks for any help.

 

[Douglas J. Steele]

Do you need both ADO (Microsoft activex data objects 2.7 library) and DAO
(Microsoft dao 3.6 object library)? If not, get rid of the reference to ADO.

From your description ("If Microsoft activex data objects 2.7 library is
placed before Microsoft dao 3.6 object library The program opens but gives a
type mismatch error message"), you're using DAO.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello
Recently I posted a question about MSAcces.exe not closing completely when

it is closed. A reply suggested I check my references.

I am using office xp (sp2) running on windows xp home edition and

professional (two different computers).

I have 256 ram.
The database has a front end (that doesn't close) and a back end.
All 'dbs' and 'rst' are closed now.
For years this was not done (I didn't know any better) and never had this problem before.

I've worked through many combinations and there are four things that may offer clues.

I've compacted the database while it was opened with this code. Could it cause a problem?

Private Sub compact_Click()

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Sub

I can open the database and closed it completely if one of the forms doesn

't have conditional formatting on a certain field.

 

[Alex]

Do you call
Application.Quit acQuitSaveNone
somewhere in your code?

 

[Guest]

----- Douglas J. Steele wrote: ----

Do you need both ADO (Microsoft activex data objects 2.7 library) and DA
(Microsoft dao 3.6 object library)? If not, get rid of the reference to ADO

From your description ("If Microsoft activex data objects 2.7 library i
placed before Microsoft dao 3.6 object library The program opens but gives
type mismatch error message"), you're using DAO

--
Doug Steele, Microsoft Access MV
http://I.Am/DougSteel
(No private e-mails, please

Hell
Recently I posted a question about MSAcces.exe not closing completely whe

it is closed. A reply suggested I check my referencesprofessional (two different computers)

I have 256 ram
The database has a front end (that doesn't close) and a back end
All 'dbs' and 'rst' are closed now
For years this was not done (I didn't know any better) an never had this problem before
Controls("Tools").
Controls("Database utilities").
Controls("Compact and repair database...").
accDoDefaultActio

't have conditional formatting on a certain field

If I put the conditional formatting in MSAcces.exe doesn't close
Visual Basic For Application
Microsoft 10.0 Object Librar
Ole Automatio
Microsoft dao 3.6 object librar
Microsoft activex data objects 2.7 librar dao 3.6 object librar
The program opens but gives a type mismatch error message (it's trying t open a recordset)
Click on end and the program goes to the main menu. When access is close MSAcces.exe closes also

Thank you for your response. It seems that using conditional formatting on a field was causing the problem

 

[Guest]

Thank you for your repsonse. It seems conditional formatting on a field was the problem.