Disconnect users

  • Thread starter Thread starter Phjart
  • Start date Start date
P

Phjart

I need to disconnect network users from mdb & lbd files to
be able to replace the files. The need may occur after a
network dropout i.e. access is terminated abnormally but
one ore more users are still connected to the files.
 
Phjart said:
I need to disconnect network users from mdb & lbd files to
be able to replace the files. The need may occur after a
network dropout i.e. access is terminated abnormally but
one ore more users are still connected to the files.
Click to expand...

If the network connection is abnormally terminated, there is a good chance
the file will be corrupted. If the ldb files can no longer be deleted from
the server UI, the only recourse is to kick the users off the file on the
server itself (or through a remote connection to it). If you still can't
clos/delete the ldb files, you'll need to reboot the server to destroy the
lock.

For normally termination, see the kickem code and database on my website:

http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Phjart said:
I need to disconnect network users from mdb & lbd files to
be able to replace the files.
Click to expand...

1) This sounds like you haven't yet split the MDB into a Front
End/Back End structure.

If not then you want to split the MDB into a front end containing the
queries, forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless.. It also supports
Terminal Server/Citrix quite nicely.

2) 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
 
Back
Top