shortcut to other users

[Kim]

I set up the security on my database using the security wizard. It created a
shortcut on my desktop which works for me. I need to get that shortcut to
other users so that they can log on using the security mdw. How do I do that?
Is it as simple as copying the shortcut to their desktops? (The database is
located on a network drive.)

 

[Joan Wild]

Yes it is. The shortcut is just a file with a lnk extension. However, it will only work if all users have Access installed in the same location (which is likely).

In addition, you should split the mdb, and each user should have a copy of the frontend on their local computer.

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

If you split, don't use the splitter wizard, as that will result in an unsecure backend. See www.jmwild.com/SplitSecure.htm for steps to split manually.

 

[Kim]

Will I have to redo the security after I split the database? This whole thing
has been a nightmare to me and the thought of having to do it again is very
daunting. I'm really a novice database creator...and it still doesn't make
sense to me...I just keep troubleshooting until I get things to work.

 

[Joan Wild]

It's easy to split a secure database - just don't use the splitter wizard. Follow the steps at www.jmwild.com/SplitSecure.htm Back up your mdb first, if you're worried.

 

[Kim]

I got to step two and it won't let me open the file because it says I don't
have permissions.

 

[Joan Wild]

Well, you have to use the correct mdw file to open the backend. I suggest you use your desktop shortcut to open the frontend. That will ensure you have an Access session going with the right secure mdw. Then hit Ctrl-O and open the backend.

 

[Olduke]

KIM:

Almost everything in Access can be learned via trial and error...EXCEPT
SECURITY. Do not enter this twilight zone without a full and complete guide.

For an excellent overview of Access security, go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little
long but it tells you everything you need to know.

 

[Tony Toews [MVP]]

Almost everything in Access can be learned via trial and error...EXCEPT
SECURITY. Do not enter this twilight zone without a full and complete guide.

That and replication are the only two things about Access which I
don't know much about. Oh yeah, subqueries too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[CY]

I am reading this thread with interest - can you explain why the database
should be split. I have seen it done successfully before but I would like
to know why it's important.

Thank you!

CY
Yes it is. The shortcut is just a file with a lnk extension. However, it
will only work if all users have Access installed in the same location
(which is likely).

In addition, you should split the mdb, and each user should have a copy of
the frontend on their local computer.

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

If you split, don't use the splitter wizard, as that will result in an
unsecure backend. See www.jmwild.com/SplitSecure.htm for steps to split
manually.

 

[Joan Wild]

Read the following:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
http://www.granite.ab.ca/access/splitapp/index.htm