Microsoft access kick someone out of a database

When you are done, just rename the file databaseoff. You must log in or register to reply here. Similar threads B. Question Access Vba to copy table from one database to another. BalloutMoe Dec 14, Microsoft Access. Replies 0 Views Dec 14, BalloutMoe. Locked Question Forgot access password!

Hyakkivn Dec 31, Microsoft Access. Replies 1 Views Dec 31, RoryA. Replies 6 Views Dec 28, petro Nov 10, kyleno. Question Relationships of different tables, and working on forms. Replies 5 Views Create a function that gets called from a Timer Event on a form that is always up in the application.

Function follows. If you want to be nice, bring up a small modal form that displays the text "You are being booted from the database. Auto Exiting in Workspaces 0. The fastest way I've found to determine if they're all out is if you can delete the. Then compact. Then enter the database and delete that record from KickEmOut, or else nobody will be able to work in the database, and they'll all be out for blood Chris Ward.

Wednesday, September 25, PM. Hello, One thing that has worked for me was to automatically exit the database after a defined amount of inactivity time. When form is opened at backend, you will get error Capture this error to close your application. This is failure proof.

Gasman Enthusiastic Amateur. Local time Today, Joined Sep 21, Messages 9, How does that kick people off the DB? Local time Today, Joined Feb 14, Messages Another way is to add a timer form and Autoexec Macro in Front End dbs, checking time of non-activity, passed a few minutes, then close all conexcion or exit from program.

See this link: www. Last edited by a moderator: Feb 23, You must log in or register to reply here. Similar threads R. Replies 13 Views Sep 29, Minty. Database locking issues.

Replies 19 Views Nov 30, Pat Hartman. Replies 24 Views Sunday at AM Cotswold. I don't see the timer code. Everything is there!

A hidden form is launched with a timer event that does the checking every The explanation is very clear in the sample database. This is the only way to boot people off. Access does not have a built-in method to do this. You can't just delete the ldb file, actually, as long as there is one person in the db, the file will be locked, you won't even be able to delete it. I'm made a back up of the database and will use that to work out the details, then implement it if the other DB ever magically becomes unlocked.

I used the code and it worked fine while with in the database, but if the settings table is a linked table I get an error. I use it all the time on a linked table. Actually, it would only work if the table is linked, otherwise it would defeat the whole purpose. Very confusing! I see you are using Access perhaps there is some limitation or a bug.