How do I open exclusive with user level security

[TammyH]

Hi -

I'm new to user level security. I have a secure database that has been
working well, but I need to make a change to a form. I tried having
everybody close it, but I think one person may have still had it open because
I keep getting the message that I don't have exclusive use. I thought I'd
try it in the off-hours, and open it exclusively, so no one else happens to
try to get in. I'm in the admin group, and I have the rights to open
exclusively, but I'm not sure how to do that since I have to use the shortcut
to open a secure database. How do I open exclusive?

Thanks!

 

[Joan Wild]

To answer your question, you can add /excl to the end of the target line in
the desktop shortcut you use to open the mdb. However....

You really should split the database. By doing so, you can work in your
copy of the frontend, and make the necessary changes to the form. Once
you're finished, you'd just distribute the updated frontend to the users.

More on splitting:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
http://granite.ab.ca/access/splitapp/index.htm

Since your database is secured, don't use the splitter wizard to split it -
do it manually; see www.jmwild.com/SplitSecure.htm

You can also automate the distribution of the updated frontend to your
users. See
http://www.granite.ab.ca/access/autofe.htm