How to set time out for MDB?

J

Jon

Greeting,

I have a MDB that will be shared on server and many users will utilize this
MDB in the future. What I want to do is making Time out for this database
once the user forgets to close a form or the database.

Any help will be highly appreciated.
 
T

Tony Toews [MVP]

Jon said:
I have a MDB that will be shared on server and many users will utilize this
MDB in the future. What I want to do is making Time out for this database
once the user forgets to close a form or the database.
Click to expand...

HOW TO: Detect User Idle Time or Inactivity in Access 2000 (Q210297)
http://support.microsoft.com/?kbid=210297
ACC: How to Detect User Idle Time or Inactivity (Q128814)
http://support.microsoft.com/?kbid=128814

However we found that the code which runs on the timer event must be
disabled for the programmers. Otherwise weird things start happening
when you're editing code.

Also print preview would sometimes not allow the users to run a menu
item to export the report to Excel or others. So you had to right
click on the Previewed report to get some type of internal focus back
on the report so they could then export it. This was also helped by
extending the timer to five minutes.

The downside to extending the timer to five minutes was if a person
stays in the same form and at the same control for considerable parts
of the day, ie someone doing the same inquiries, the routine didn't
realize that they had actually done something. I'll be putting in
some logic sometime to reset this timer whenever they do something in
the program.

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/
 
A

aaron.kempf

If you need to do something like this; you should be using SQL Server.

With SQL Server it is _QUITE_ easy to close a connection based on a
SPID.

If you need to determine which process is causing problems; you can
execute 'sp_who' in Query Analyzer.

If you need to determine what your current Spid is; then you can use
'Select @@Spid' in order to get to this variable.
ANd then if you need to close a connection you can launch a command
like this

kill 59

this command will close the connection for processID (spid) = 59.

Thanks and good luck

-Aaron
 
T

Tony Toews [MVP]

Jon said:
I have a MDB that will be shared on server and many users will utilize this
MDB in the future. What I want to do is making Time out for this database
once the user forgets to close a form or the database.
Click to expand...

Be advised that Aaron Kempf has a SQL Server answer to every question
regardless of how relevant the answer is.

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/
 
A

aaron.kempf

Tony;

Like my 'reccomending SQL Server' is a _BAD_ thing?

Give it up-- I've asked you many times to stop stalking me.
It is illegal to run around; stalking me-- looking up and posting my
IP addresses.

Putting up websites that attack my character and give false
information.

I refuse to be bullied by a MDB cry baby.

Leave me alone _IMMEDIATELY_ Tony; I do not feel safe in my own
house- I thnk that you are stalking me.
I frequently hop on the computer; and I notice that you're posting
_IMMEDIATELY_ after mine-- are you waiting outside my house or
something?

I don't feel safe with your personal attacks.

Thanks

-Aaron
 
T

Test

--
Tes
Tony

Like my 'reccomending SQL Server' is a _BAD_ thing

Give it up-- I've asked you many times to stop stalking me
It is illegal to run around; stalking me-- looking up and posting m
IP addresses

Putting up websites that attack my character and give fals
information

I refuse to be bullied by a MDB cry baby

Leave me alone _IMMEDIATELY_ Tony; I do not feel safe in my ow
house- I thnk that you are stalking me
I frequently hop on the computer; and I notice that you're postin
_IMMEDIATELY_ after mine-- are you waiting outside my house o
something

I don't feel safe with your personal attacks

Thank

-Aaro


On Mar 22, 12:42=A0am, "Tony Toews [MVP]" <[email protected]
wrote
 
A

aaron.kempf

Hey I don't know who you are, or what you're doing

BUT STOP FOLLOWING ME AROUND

-Aaron
 
T

Tony Toews [MVP]

[email protected] said:
Give it up-- I've asked you many times to stop stalking me.
It is illegal to run around; stalking me-- looking up and posting my
IP addresses.
Click to expand...

Posting what IP addresses?
Putting up websites that attack my character and give false
information.
Click to expand...

What web sites that attack your character and give false information?

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/
 
A

aaron.kempf

Don't play dumb Tony. I mean, get real.

I saw your website.

It is called Libel; Tony.

Chasing 20 different people around saying 'oh, I think that you're a a
r o n k e m p f'
and making websites with lies and propaganda and a bunch of
accusations?

You should be in jail, stalker.

Stop following me and stop posting to me.
IMMEDIATELY

stalker

-Aaron
 
A

aaron.kempf

and for the record; I am compiling a list of 2,000 posts where you
have said 'oh I think that this person is a a r o n k e m p f

you have been stalking me for years, Asshole.
Just because you've got short mans complex and you play with a baby
database.

I insist that you leave me alone, STALKER

STOP ATTACKING ME

-Aaron
 
T

Tony Toews [MVP]

[email protected] said:
Don't play dumb Tony. I mean, get real.

I saw your website.
Click to expand...

Then post the URL.
It is called Libel; Tony.
Click to expand...

So sue me.
Chasing 20 different people around saying 'oh, I think that you're a a
r o n k e m p f'
and making websites with lies and propaganda and a bunch of
accusations?
Click to expand...

Tell me which were lies.

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/
 
A

aaron.kempf

Tony;

They were all unprovable accusations.

You're not a forensics engineer.
Have you ever worked in internet security?

You have no right to follow me around and attack everything I say.

I swear to god Tony.
STOP FOLLOWING ME AROUND ATTACKING EVERYTHING THAT I SAY.

I am not a TROLL-- I am your superior.

I work on real databases-- and you work on the little baby databases.

You will stop following me around and attacking me for no reason.

THANKS FOR YOUR COOPERATION IN THIS _CRIMINAL_ MATTER.

-Aaron Kempf
 
A

aaron.kempf

which were lies? THEY ALL ARE.

You have no idea which of those posts were made by _ME_ and which of
those posts are made by imposters. I've already demonstrated 100
times that I've got imposters that run around on the internet; posting
stuff under my name.

I don't care about the past.

I CARE ABOUT STOP THINK AND DO NOT STALK ME, ASSHOLE.

Why do you run around 2,000 times and say 'oh, I think that you are a
a r o n k e m p f.

I refuse to be stalked like this.

STOP FOLLOWING ME IMMEDIATELY AND POST A RETRACTION FOR ALL OF YOUR
RECENT NEGATIVE COMMENTS.

-Aaron
 
P

pietlinden

Then post the URL.


So sue me.


Tell me which were lies.

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 athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Click to expand...

I'm starting to think Aaron Kempf is a reincarnation of Don Mellon...
 
A

aaron.kempf

Pete;

I'll take your criticisms elsewhere buck-o.
Don't follow me around talking shit, I will not put up with it.

I make more money than any of you idiots. I still get to use my
favorite Access Forms and Reports.. I just don't have to deal with
your tedium.

You can stick your personal attacks elsewhere.

I hereby warn you to not criticize me online.

Thanks

-Aaron
 
A

aaron.kempf

And Piet-- If you wanted to have _ANY_ part of this conversation?

Maybe you'd realize that Tony Toews is the stalker all along.

Was Don Mellon _REALLY_ that bad?

Maybe I'll research it more. Personally i think that the real problem
is Tony Toews. He gives false information. He attacks people.

I'm not going to put up with your attacks, Piet.

I suggest that you keep your nose where it belongs and no longer
attack me.

Thanks

-Aaron
 
V

Vincent Huang

What's a "ronkemph"?
Don't play dumb Tony. I mean, get real.

I saw your website.

It is called Libel; Tony.

Chasing 20 different people around saying 'oh, I think that you're a a
r o n k e m p f'
and making websites with lies and propaganda and a bunch of
accusations?

You should be in jail, stalker.

Stop following me and stop posting to me.
IMMEDIATELY

stalker

-Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open .mdb file by double click when another user has opened 5
Wise to set up user level security for a multi FE MDB ?? 9
Permissions / Closing MDB left open 1
How do I set focus (and select text) on a text box on a modeless userform? 0
mdb looks and acts like mde 3
Split .mdb back-end 4
Remove 1 from stock with everu barcode scan 1
form load in accdb is slower than in mdb 1

Top