force people out from the database

[K]

Hi all, I work in office and I created a database which is on network
drive and every one in the office use it. I need to update the
database time to time and for that I have to shout at every one to
come out from the database so I can update it. Can any friend know
the way that i can have a button on my database by clicking it should
force everyone out from the database. I dont know if its possible but
I would be very greatful if any friend can help

[Douglas J. Steele]

Take a look at http://msdn.microsoft.com/en-us/library/bb243861.aspx (Don't
worry if you're not using Access 2007: the technique works in all versions
of Access).

However, if your application has been deployed properly, you should seldom
require this capability. All Access applications should be split into a
front-end (containing the queries, forms, reports, macros and modules)
linked to a back-end (containing the tables and relations). Only the
back-end should be on the server: each user should have his/her own copy of
the front-end, ideally on his/her hard drive.

Once you're happy that all of the changes to the front-end are correct, you
use a tool such as the free Auto FE Update which Tony Toews has at
http://www.autofeupdater.com/ to ensure that each user has the current
version.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"K" <kamra...@yahoo.co.uk> wrote in message
news:36f2e130-7f99-4123...@k4g2000yqb.googlegroups.com...