Process not terminating

[Question Boy]

I have a very simple db. When I cose it using Access' close button or the
Exit button I put on my switchboard (which calls docmd.quit) the application
disappear from sight (no longer visible) but the process remain in my task
manager. What could be the cause of this? Is the a remedy?

Thank you,

QB

 

[BruceM]

Is it there before you start the database? How about other Office
applications such as Word? Perhaps you have Office in your Startup options.

 

[Question Boy]

I make sure I kill it prior to launching it again. So no it is not present
when I open the database.

It is only happening with Access, no other app. Office Startup option?
Where can I locate these?

QB

 

[a a r o n . k e m p f]

Access / DAO Hangs-- unless you write your code in a very particular
order.

That is one of the three main reasons that I moved to SQL Server a
decade ago.

Yes- Access rocks. But Jet? Jet / DAO is just plain STUPID.

Any library that hangs like this-- should be replaced.

-Aaron

 

[BruceM]

Click the Start button. Depending on the OS, click Programs or All
Programs, and look for a Startup folder.

What do you mean by "I make sure I kill it prior to launching again"? Do
you use Task Manager to kill it manually, or what exactly?

 

[Question Boy]

I do not remember using any dao, but I will take a closer look at my code.

 

[Question Boy]

Yes, I kill the process using the tack manager as I have no alternative since
the graphical interface is gone. what I do not understand is the graphical
interface disappears/close and the lock file is gone, so how can the process
still be there. Still a lot I know nothing of in the IT world and basics of
software applications.

My startup has nothing regarding to Office.

QB

 

[Question Boy]

What I also don't understand is my db is 1.5Mb, but when create a new db and
import everything it is only 888Kb? Shouldn't a compact and repair result in
the same size? Even after transfering everything to a new db it hangs.

Qb

 

[BruceM]

What happens with Access.exe if you create a new mdb file with a single
table and no code, then close the mdb? How about if you create a form based
on the table?
Another thing to try is commenting out all of the code in your database, and
closing it with the X in the top corner. If all is well with this approach,
uncomment the code one sub or function at a time.
What I'm getting at here is that Access may "think" something is still
running. Perhaps a recordset is left open (although I think that would
leave behind a lock (ldb) file. Whatever the details, you should be able to
determine whether this problem is specific to this file or if it applies to
any Access session. If the former, it should be possible to narrow it down.

 

[Tony Toews [MVP]]

I do not remember using any dao, but I will take a closer look at my code.

Aaron's answers are usually incorrect. Please don't waste any time
looking for alleged DAO problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Dirk Goldgar]

I have a very simple db. When I cose it using Access' close button or the
Exit button I put on my switchboard (which calls docmd.quit) the
application
disappear from sight (no longer visible) but the process remain in my task
manager. What could be the cause of this? Is the a remedy?

The usual cause of this happening is objects that are created in code and
not properly closed or disposed of. There was also a bug involving certain
kinds of references to check box controls in, I believe, Access 97 and 95.

What version of Access are you using? You say it's very simple -- what VBA
code do you have in it that you wrote yourself? Do you experience this
problem even if you just open the database and then close it right away? If
so, we may be able to localize the problem to your switchboard form
(assuming that's your startup form).

 

[Tony Toews [MVP]]

I have a very simple db. When I cose it using Access' close button or the
Exit button I put on my switchboard (which calls docmd.quit) the application
disappear from sight (no longer visible) but the process remain in my task
manager. What could be the cause of this? Is the a remedy?

What version of Access?

Access minimizes to Windows 95/NT toolbar instead of closing
http://www.mvps.org/access/bugs/bugs0005.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/