Opening a Locked File to make changes

[Fasby]

I have setup a shared file on a network. At this point I have not
established any security for the database, however at times I need to make
modifications to forms/queries/code and I am prohibited from doing so until I
can have everyone exit the database. Is their a way for me to override the
file while other users are in it to take exclusive control? Waiting for all
users to exit does not always work since some of the changes need to be made
right away. Any suggestions?

 

[Jack MacDonald]

split your database into frontend & backend components. See
http://www.granite.ab.ca/access/splitapp/index.htm
for a full explanation.

I have setup a shared file on a network. At this point I have not
established any security for the database, however at times I need to make
modifications to forms/queries/code and I am prohibited from doing so until I
can have everyone exit the database. Is their a way for me to override the
file while other users are in it to take exclusive control? Waiting for all
users to exit does not always work since some of the changes need to be made
right away. Any suggestions?

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

['69 Camaro]

Hi.

Several people have written utilities to kick users out of the database.
Please see the following Web page for links to several of them:

http://groups.google.co.uk/groups?hl=en&lr=&th=991477a993370edc&rnum=1

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)