Create a text file named "!Shutdown.txt". No data is needed in the file. Create a hidden form with a timer routine that looks for the file "Shutdown .txt" every few minutes. When it finds the file, it pops up a messages to all users that the database will close in 1 minute. Then it closes the database. Of course, if it doesn't find the file, nothing happens. When you need to update the database, just rename the text file to remove the "!".
Hope this helps Bob owen_group_profile wrote: > Sometimes that happens to me when the .mdb file is on a network, even > if there is no-one currently using the file. > > I don't know why it occurs, but I've found that I'm able to simply > delete the .ldb file and then everything works fine. > > I'm not sure that this will work in your case, but can't hurt to try. > > Owen > > > > --- In [email protected], "Sean" <[EMAIL PROTECTED]> wrote: > > Does anyone know of a way to kick users out of a database. I have a > > user do did not log out of the database and is out for a few days and > > we need to modify the database. > > > > Thanks for any help. > > > > ------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > * Visit your group "AccessVBACentral > <http://groups.yahoo.com/group/AccessVBACentral>" on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------------------------------------------------ > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
