If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to force people out of access database
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 |
#2
|
|||
|
|||
Need to force people out of access database
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" wrote: 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 |
#3
|
|||
|
|||
Need to force people out of access database
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 "KARL DEWEY" wrote: 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" wrote: 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 |
#4
|
|||
|
|||
Need to force people out of access database
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 "Emma Hope" wrote in message ... 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 "KARL DEWEY" wrote: 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" wrote: 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 |
#5
|
|||
|
|||
Need to force people out of access database
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 "Emma Hope" wrote in message ... 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 |
#6
|
|||
|
|||
Need to force people out of access database
Emma Hope wrote:
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 -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/ |
#7
|
|||
|
|||
Need to force people out of access database
"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. -- Dave Hargis, Microsoft Access MVP "Tony Toews [MVP]" wrote: Emma Hope wrote: 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 -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/ |
Thread Tools | |
Display Modes | |
|
|