Need to force people out of access database

[Emma Hope]

Hi All,

Some help please. I used to work for a company and have since left, i am
still maintaining some databases through a remote hamachi login.

I desperately need to make some changes for one of our users but someone has
left the database open on their PC & therefore i can't make the changes and
as the office is closed, i can;t get them out.

Is there any way i can force them out of the database in this situation.

Thanks
Emma

 

[KARL DEWEY]

In the past where I was database administrator and it was known by the LAN
Manager I would have them dumped by him.

 

[Emma Hope]

Hi Karl,

Unfortunately, a small company, the 'web guy' is also the 'IT guy' and
pretty much has responsibility for anything with a plug on it & really hasn't
a clue about most of it, surprised the systems still run to be honest with
you. Also one of those guys that does 9 to 5 and woe betide if he has to work
5 mins over...i hope he doesn't read these pages.....

I guess it's not possible with the constraints i have....

Thanks anyway.
Emma

 

[tina]

this won't help you at this moment...but for the future, suggest you
consider writing some code to automatically close the database after a
certain hour. one way to do this is to open a hidden form when the db opens,
and leave it open until the db is closed. set the timer event to run
periodically (perhaps every 15 minutes). in the timer event procedure, add
code to check the current time and close the db if the time is after a
certain hour of the day (7 pm, for instance). you'll want to include code
that loops through all open forms and closes them before quitting the
database.

hth

 

[Gina Whipp]

Emma,

What I would suggest is sending out an eMail that says...

I was unable to make requested changes to your database because someone
inadvertently left their database front end open. Please advise when we can
reschedule.

In the future, since you don't have the ability to log them out, I would
send an eMail before days end to left everyone know updates will be applied
and to please log off. OR I would also talk to the 'IT Guy' and ask for a
phone number to call for situations just like this OR maybe some Admin
rights so you can do your work.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tony Toews [MVP]]

I desperately need to make some changes for one of our users but someone has
left the database open on their PC & therefore i can't make the changes and
as the office is closed, i can;t get them out.

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

 

[Klatuu]

"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."

I haven't had that problem since Monday.