 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / January 2008shortcut to other users
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.) 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.  SignatureJoan Wild Microsoft Access MVP >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.) 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. > 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). > [quoted text clipped - 11 lines] > > Is it as simple as copying the shortcut to their desktops? (The database is > > located on a network drive.) 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. SignatureJoan Wild Microsoft Access MVP > 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 [quoted text clipped - 16 lines] >> > Is it as simple as copying the shortcut to their desktops? (The database is >> > located on a network drive.) I got to step two and it won't let me open the file because it says I don't have permissions. > 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. > [quoted text clipped - 18 lines] > >> > Is it as simple as copying the shortcut to their desktops? (The database is > >> > located on a network drive.) 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. SignatureJoan Wild Microsoft Access MVP >I got to step two and it won't let me open the file because it says I don't > have permissions. [quoted text clipped - 21 lines] >> >> > Is it as simple as copying the shortcut to their desktops? (The database is >> >> > located on a network drive.) 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. > 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. > [quoted text clipped - 23 lines] > >> >> > Is it as simple as copying the shortcut to their desktops? (The database is > >> >> > located on a network drive.) >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 SignatureTony 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/ 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. SignatureJoan Wild Microsoft Access MVP >I set up the security on my database using the security wizard. It created >a [quoted text clipped - 4 lines] > is > located on a network drive.) Read the following: http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm http://www.granite.ab.ca/access/splitapp/index.htm SignatureJoan Wild Microsoft Access MVP >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 [quoted text clipped - 3 lines] > > CY |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.