By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Kick users off Access

P: 74
Is there a way i can Kick people off useing the front end database so i can preform updates?
Jun 13 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,308
Is there a way i can Kick people off useing the front end database so i can preform updates?
Only by walking around to their desk I'm afraid. otherwise you can kill the connection remotely, but I wouldn't think that were safe to do.
Jun 13 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Only by walking around to their desk I'm afraid. otherwise you can kill the connection remotely, but I wouldn't think that were safe to do.
I believe there is some code floating around somewhere that will allow you to read the ldb file to find out who is logged on and send them a network popup asking them to log off.

I think the best thing is just to email the users asking them to log off.

Updates should not be done on the live version. One of the main reasons for having a frontend is so you can make amendments to a copy and simply replace the existing frontend with the copy.

I'll try to find that code for reading the ldb

Mary
Jun 13 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
OK

Found it quite quickly

http://www.ukaug.co.uk/TPMaintain.asp
Jun 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.