Opening database Exclusively

[tpeter]

I have secured the Access database 2003 with the wizard and everything works
correctly. I need to make changes sometimes and this database is setup with
multiple users. I have given myself full permision but I can't open the
database exclusively. You have to use the shorcut to open the database and
you can't open the shorcut exclusively. Am I missing something or when user
level security is in place you loose the ability to open exclusively. Thank
you for your help.

 

[Joan Wild]

You should split the database, if you haven't done so yet. Firstly you'll be able to implement and test changes before putting into production, and secondly you won't have to worry about opening exclusively.

If you have already split, and are referring to opening the backend to make design changes, you can add /excl to the shortcut target to open it exclusively. Security does not hamper the ability to open exclusively.

--
Joan Wild
Microsoft Access MVP
:I have secured the Access database 2003 with the wizard and everything works
: correctly. I need to make changes sometimes and this database is setup with
: multiple users. I have given myself full permision but I can't open the
: database exclusively. You have to use the shorcut to open the database and
: you can't open the shorcut exclusively. Am I missing something or when user
: level security is in place you loose the ability to open exclusively. Thank
: you for your help.

 

[tpeter]

Yes,

The database is already split. You can only access the database threw the
shortcut (that I am aware of). Where do I put excl in the path? Should I
have 2 shortcuts, one for normal use and one for editing? Thank you for your
help.

 

[Tom van Stiphout]

On Thu, 12 Jun 2008 17:07:01 -0700, tpeter

Make a copy of your normal shortcut. At the end of it, add:
/excl

Or look it up in the Access help file, topic=command line.

-Tom.

 

[Joan Wild]

If you are editing the backend database, you'll have to choose a time when no one is using it; you can't make design changes while in use.

You can use your existing shortcut to open the frontend and log in; then just hit Ctrl-o and open the backend - click the dropdown beside the Open button and choose Open Exclusively

--
Joan Wild
Microsoft Access MVP
: Yes,
:
: The database is already split. You can only access the database threw the
: shortcut (that I am aware of). Where do I put excl in the path? Should I
: have 2 shortcuts, one for normal use and one for editing? Thank you for your
: help.
:
: "Joan Wild" wrote:
:
: > You should split the database, if you haven't done so yet. Firstly you'll be able to implement and test changes before putting into production, and secondly you won't have to worry about opening exclusively.
: >
: > If you have already split, and are referring to opening the backend to make design changes, you can add /excl to the shortcut target to open it exclusively. Security does not hamper the ability to open exclusively.
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > :I have secured the Access database 2003 with the wizard and everything works
: > : correctly. I need to make changes sometimes and this database is setup with
: > : multiple users. I have given myself full permision but I can't open the
: > : database exclusively. You have to use the shorcut to open the database and
: > : you can't open the shorcut exclusively. Am I missing something or when user
: > : level security is in place you loose the ability to open exclusively. Thank
: > : you for your help.
: >

 

[tpeter]

Thanks to both of you either option worked great. I would just like to say
thank you to everyone for there help, this is an invaluable sight.