Access closing by itself

[Guest]

Does anyone know of a setting that makes access close by itself when you are
not using it? or in microsoft.
But I think it only happens to his access database, no other applications.

 

[Joseph Meehan]

Does anyone know of a setting that makes access close by itself when
you are not using it? or in microsoft.
But I think it only happens to his access database, no other
applications.

Are you saying that someone is having Access close by itself and you
want to find out how that is happening so you can control it or you want to
add that feature?

If so, then does this happen with all or some mdb/mde files? Does it
happen if you have not opened an mde or mdb file?

 

[Guest]

It's one of those things that doesn't happen all the time. I'm trying to
stop it. It may just be an issue that is resolved by restarting, but thought
I'd ask the question.
We don't use any other databases, so don't know if it does it to them. The
whole of access shuts down. He has done nothing to it (as far as he is aware)

 

[Guest]

If the database shuts itself down while using it, that's a sign of
corruption. I've seen this behavior when entering a corrupt memo field and a
few other times. Unfortunately a Compact and Repair doesn't seem to fix Memo
field issues very well.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Bill Mosca, MS Access MVP]

Most likely there is a hidden form with a timer event that checks for
inactivity. I use this method on all my multi-user databases so users do not
open a database and then leave the office. Look at the startup form's open
or load event to see if it is opening a form as hidden. If there is a macro
named Autoexec, check to see if it is opening such a form.

Once you find teh name of the hidden form, open it in design view and look
at teh code to see if this is using a Quit command to close Access.

 

[Trey Davis]

YOU ARE SO STUPID

YOU DON'T MAKE ANY SENSE

 

[Joseph Meehan]

YOU ARE SO STUPID

YOU DON'T MAKE ANY SENSE

What are you doing on a computer at this time of day. You should be in
school and you should not use school computers for your poor quality
trolling.

 

[Anthony]

WTF!

WTF DOES DIA DUIT MEAN

What are you doing on a computer at this time of day. You should be in
school and you should not use school computers for your poor quality
trolling.

 

[Bill Mosca, MS Access MVP]

Trey

Didn't you just post a broadcast apology for being a jerk? I for one am done
with you. May you have an interesting life.

 

[Joseph Meehan]

WTF!

WTF DOES DIA DUIT MEAN

"May God be with you" in Irish Gaelic