Kick someone out of a database

[adz2013]

Is anyone aware of a tool that will kick someone out of a database? There is one person in a database that I need to do something to and no one can get access to the computer. The person is away and there door is locked. They have the database opened and I want to close it out.

Any help would be great.

 

[Autoeng]

Check out www.rogersaccesslibrary.com. There is a good example there.

Autoeng

 

[Autoeng]

Another thing you should be doing if you're not is only working on a copy of the db and then replacing the actual db with the updatedcopy. Have you split your db? If you have I have some other hints for you. Want to make a change to the front end only? Create a batch file that copies the front end to the users pc on open of the db. Now when you want to chang the front end you don't even have to kick people out of the db because they are in their own copy of the front end. You will have to kick them out to update the back end however.

Autoeng

 

[adz2013]

Thank you Autoeng, I will look into the website. Also I do not have it split out, but I just need to compact and repair the database because there is a problem with another user. I am not changing anything in this database. I would be interested in your example of having each user have there own front end. I have another database which might be a good one to use that on.

Thanks again.

 

[adz2013]

Autoeng,

Do you know where on the site I might find the tool. I looked but could not find it. I will keep looking but if you know that would be great.

 

[Autoeng]

Just use Notepad to create a batch file using old DOS commands.

Here is mine
md "c:\my documents"
copy s:\everyone\ecndatabase\BereaECN.mdb "c:\my documents\*.*"
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\my documents\BereaECN.mdb" /WRKGRP "s:\everyone\ecndatabase\ecndatabase.mdw"


Explaination
md "c:\my documents" (this makes a directory as we have Win 2K and Win NT users and the directory doesn't exist for Win NT users, it doesn't fire if the directory already exists)

copy s:\everyone\ecndatabase\BereaECN.mdb "c:\my documents\*.*" (this copies the front end to the users pc directory)

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\my documents\BereaECN.mdb" /WRKGRP "s:\everyone\ecndatabase\ecndatabase.mdw"(my db is secured so I have to load the workgroup when opening)

Using this method you can send the batch file to users via email, have them copy to their desktop and use it to access the db. Now you can replace the front end with new versions any time you want without having the users log out.

Autoeng

 

[Autoeng]

Look under the appropriate Access version download link for the file "Logusersoff(97 or 2K).mdb"

Autoeng

 

[adz2013]

Thank you I got it.
And thank you for the other code.

 

[harra]

Along the lines of what Autoeng suggested, I have been using a "portal" database solution.

Basically, the user lauches what they think is the database they want to use, but really it just copies a couple files to their harddrive and then launches the database. It copies the front-end .mdb and a shortcut file. The shortcut file is just an easy way for me to get them to launch the portal without having them go to the same location on the network each time.

The locations of the files is stored in a table in the Portal database so whenever the location of the database files change, all I need to do is change the data in the tables and the user is none the wiser