Detect user idle time

[LG]

Hi,

I have lately used the microsoft detect user idle time coding in the
access database I'm having and it works excellent if you just log in
without moving through forms or adding any data because as soon as you
do that and you walk away from the computer and the code detects that
you are idling, instead of closing the database - I have a form where
you can cancel if you want to continue or it will shutdown - I'm
getting an error message that "Microsoft has encountered a problem
and needs to close".
Do you know how can I prevent that thing ever happen again?
Thank you in advance.

 

[Albert D. Kallal]

have you tried running the application as a mde...does this also behave this
way?

Is the database multi-user? Is it split?

You should give a short rundown of your setup. Are the service packs
installed? Heck, what version are you running?

You should give a bit more information about your setup, as makes it
difficult to pin down anything with your given setup.

So, since you did not give much to go on, and did not give anything about
your current setup (even what windows, and what version), then the best
advice I can give is to do the following:

first, if mutli-user, split
install the latest bug fixes for your version (that means install the
service pack updates)
try running your application as a mde.

Do the above 3 things...did that help?

 

[LG]

Database in question (version 2002) is a multi-user but not split and i
have installed SP3.
i am going to try to run application as a mde.
here is the idling code that i am using...

http://support.microsoft.com/?id=128814

thanks.

 

[LG]

i've tried to run database as a MDE (Tools>Database Utilities>Make mde
file) but i am getting the same error message...microsoft has
encountered a problem and needs to close...
really,really frustrating.

 

[Albert D. Kallal]

i've tried to run database as a MDE (Tools>Database Utilities>Make mde
file) but i am getting the same error message...microsoft has
encountered a problem and needs to close...
really,really frustrating.

Sounds like your database is really in bad shape, likely corrupted (this
would be the result of allowing multiple users, and not splitting).

Try a compact and repair. Further, create a new blank database, and import
everything.

The fact that you can't even create a mde likely means that you likely can't
even compile your code. (does your code compile?)

do note that you must be able to compile your code BEFORE you can try and
make a mde....

 

[LG]

I just wanted to let you know that i am still trying, so far nothing
worked.
thank you.

 

[Douglas J. Steele]

Consider decompiling your code (see what Tony Toews has at
http://www.granite.ab.ca/access/decompile.htm for how)

If that still doesn't work, create a new database and import everything from
the old database into the new one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I just wanted to let you know that i am still trying, so far nothing
worked.
thank you.

 

[Albert D. Kallal]

I just wanted to let you know that i am still trying, so far nothing
worked.
thank you.

What happens when you try and compile your code?