How do I disconnect users from a DB?

[Ian Weiting]

I have a data .mdb file in a central location that a few
users connect to using an access frontend. I need to know
how to disconnect all users from the data db so I can
replace it with one that has updated data. The file is
locked while in use and I can't seem to get them all to
release it overnight.

How do I manually disconnect users from an access db?

Ian Weiting
ATB Financial

 

[KW]

Have a table in your database that all users have access
to. This table will have one field and one record. If you
need everone to log off, set the value in that table to
some value of your choice. Have a form in the application
(on the users computer) that is hidden. Have an ontimer
event that would check the value in that table say once a
minute. If the value in the table is set to the value of
your choice, it informs the user to log off, then resets
the timer intervasl to some shorter time and sets a flag
on the hidden form. When it fires the second time, it
should then shut down the application. The timer interval
property is in microseconds, have it fire once a minute or
so.

I hope this is not to confusing. I saw this basic approach
described a week or two ago by someone else.

Kevin