msaccess keeps running as process

[Guest_imported]

I have several front-ends working out of two databases. One of my front-ends seems to leave msaccess running in the task manager of windows after complete shutdown. I have to end the process to reopen the front end....is there anything i should look for?... I have made sure i closed all my open recordsets and such... Does anyone know of a common problem that causes this?

 

[LarryDeLaruelle]

Bryan:

Are you using any recordsets?

If you open a record set, work on it and then leave it open this will cause the symtom you describe.

It's always a good idea to close any open recordset and set the temporary database to nothing:

rsTemp.Closed
Set dbTemp = Nothing

Check the code for any instance where a recordset has been created but not closed. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[LarryDeLaruelle]

Bryan:

Are you using any recordsets?

If you open a record set, work on it and then leave it open this will cause the symptom you describe.

It's always a good idea to close any open recordset and set the temporary database to nothing:

rsTemp.Closed
Set dbTemp = Nothing

Check the code for any instance where a recordset has been created but not closed. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[archery]

Another thing to look for (and is REALLY wierd) is for any Boolean compares. There is an identified bug (and as far as I know, as yet not corrected) where if you have code such as:


IF bol_YourField THEN
..... do something
( Else) ......
( Endif)

It should be changed to

IF bol_YourField = TRUE THEN

( etc )


Even though the first example is "suipposed" to be equal to ( IS TRUE ), such coding will cause Access to remain in the Task Bar.
This does, however, ONLY occur IF the actual line of code is "processed" (i.e. you run the module which contains that offending code)

HTH