Access doesn't close

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Hello,

I am using the API from the Access Web (fSetAccessWindow) to hide the Access
window in an application. I discovered that the application continued to
run after I quit, and I then need to close it in the Processes window of the
Task Manager. This is an Access Project.

Is there a fix for this problem? I tried restoring the Access window before
shutting down, but that didn't resolve it.

Thanks and God Bless,

Mark A. Sam
 
I discovered it isn't the Function causing the problem, it is opening a
particular form. I'll need to do some elimination.
 
Mark A. Sam said:
Hello Dick,

It is Access 2002. It isn't the boolean bug or leaving a recordset
open. I don't use implicit references and there are no recordsets
address on this app. But it gives me ideas, becuase I am assigning
RecordSources and Rowsources in code which is somethign I can look
at.

This is an Access Project attached to a remote SQL Database. I
attached a copy of the .ade in case you or anyone else wants to test
it on their machine and see if the problem exists there. It may be
my computer rather than the db.

This is a winzip file.
Click to expand...

Although you're not supposed to post binary attachments in these
newsgroups, I went ahead and ran your ADE -- because I know and trust
you -- and it left msaccess.exe running in the background after I closed
it, just as you say it does for you. Since it's an ADE, I can't look at
the code to see what may be going on, but at least you know it's not
just your computer.
 
OOps, I didn' t know that about the binary attachments, and apologize for
it. I appreciate your feedback.

God Bless,

Mark
 
I cleared the event procedure properties that I had on the form
([EventProcedure]) and that seem to to fix the problem When I reset the
properties, it was still fixed.

Must have been one of those Time/Space anomalies. ;)
 
Back
Top