Force Kick Off

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I realize this question is braught up often. However, I did not find what
I'm looking for. I have a database (access XP) sitting in a shared network
drive. I would like to know, how I can kick or force (whichever term you
want to use) the users from the database. to do any design modifications.
Currently, it is preventing me from going to the design view to change
things.

I don't want to know who is working on the database (idl timer), I just want
to kick them off. I realize that I can set it up to see if there are any
acitivities on the database by the users. But, I don't want that. I just
want to kick them off. That's all, Period. Well, maybe a warning message
might help. But that's not my concern at this stage. Thank you for your help.


John
 
I have a database (access XP) sitting in a shared network
drive.
Click to expand...

Run, do not walk, to the Database Splitter Wizard.

You will get a LOT better performance, less bloat, less corruption,
and a solution to this problem by splitting your database into a
"backend" containing the tables, and a "frontend" which is distributed
so that each user has their own copy. This contains links to the
tables in the backend and all your forms, reports, etc.

When you are creating new forms and the like, do so in your own copy
of the frontend; get it up and running and tested; then just give each
user a new copy of the frontend.

John W. Vinson[MVP]
 
Back
Top