Re: Different Users for Access 2000
From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 07/30/04
- Next message: Lynn Trapp: "Re: Change password form without user account info showing"
- Previous message: Lynn Trapp: "Re: Change password form without user account info showing"
- In reply to: Kelvin: "Re: Different Users for Access 2000"
- Next in thread: Joan Wild: "Re: Different Users for Access 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Jul 2004 08:15:35 -0500
The first part should work just fine, but you will need to change the path
to the db and the path the the security file.
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Kelvin" <yew_mhis@intr.mhi.co.jp> wrote in message news:6df501c475d2$d2f17d00$a301280a@phx.gbl... The database that I am going to create is going to be stored in the main server eventually and all 6 users, including me will be connected to the main server. Will the link that I have created earlier still works? "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Kelvin's doc\Access Testing\db1.mdb" /wrkgrp "C:\Kelvin's doc\Access Testing\SECURITY.mdw" Or Must I re-create the workgroup (.mdw) in the server itself and perform the steps again on the database stored in the server? Or Work on my desktop first, like what I currently did. When the database is stored to the server, I just need to change the "path to mdb"? >-----Original Message----- >You only need to create the users once. Give each of them a copy of the >shortcut for their desktop. Also, make certain that all of them have Read, >Write, and Delete permissions to the folder the database is stored in. > >-- >Lynn Trapp >MS Access MVP >www.ltcomputerdesigns.com >Access Security: www.ltcomputerdesigns.com/Security.htm > > >"Kelvin" <yew_mhis@intr.mhi.co.jp> wrote in message >news:1b8201c46f89$aa8fa5c0$a501280a@phx.gbl... >Thanks for all the assistance provided. > >As there will be a total of 6 users including myself, I >will need to create 6 users and assigned the appropriate >permissions to different users. > >After doing that, do I just create the shortcut on every >of the 6 computers in order for this to take place? Or do >I have to repeat all the steps for all 6 PCs? > >>-----Original Message----- >>It sounds like you have it working correctly. You got the >error message you >>should have gotten when trying to open the database >directly. Way to go. >> >>-- >>Lynn Trapp >>MS Access MVP >>www.ltcomputerdesigns.com >>Access Security: www.ltcomputerdesigns.com/Security.htm >> >> >>"Kelvin" <yew_mhis@intr.mhi.co.jp> wrote in message >>news:0f6301c46ec7$3ca65ee0$a601280a@phx.gbl... >>> When I switched back to the original .mdw file (not the >>> one I created) and tried opening the database, there was >>> an error message saying I do not have the necessary >>> permissions. Is Joan referring to this? >>> >>> Also, I tried to access the database using the shortcut >>> that I have created, it works! >>> >>> Is this it? >>> >-----Original Message----- >>> >Yes. So am I on the right track? >>> >>-----Original Message----- >>> >>> According to Joan's website, I should not be able to >>> >open >>> >>> the database at all. But for my case, I am prompted >the >>> >>> user password which I have created in Step 13. >>> >>> >>> >>> Have I done anything wrong here? >>> >> >>> >>Do you mean you can open it by double clicking on >>> >the .mdb file in windows >>> >>Explorer and you get the logon prompt? That merely >means >>> >that you are joined >>> >>to the security.mdw file. >>> >> >>> >>-- >>> >>Lynn Trapp >>> >>MS Access MVP >>> >>www.ltcomputerdesigns.com >>> >>Access Security: >www.ltcomputerdesigns.com/Security.htm >>> >> >>> >> >>> >>"Kelvin" <yew_mhis@intr.mhi.co.jp> wrote in message >>> >>news:038201c46dfd$32432070$a301280a@phx.gbl... >>> >>> Thanks for the explanation. I have successfully >create >>> >the >>> >>> desktop shortcut with the following target: >>> >>> >>> >>> "C:\Program Files\Microsoft >>> >>> Office\Office\MSACCESS.EXE" "C:\Kelvin's doc\Access >>> >>> Testing\db1.mdb" /wrkgrp "C:\Kelvin's doc\Access >>> >>> Testing\SECURITY.mdw" >>> >>> >>> >>> According to Joan's website, I should not be able to >>> >open >>> >>> the database at all. But for my case, I am prompted >the >>> >>> user password which I have created in Step 13. >>> >>> >>> >>> Have I done anything wrong here? >>> >>> >>> >>> For "path to secure mdw", do we set the target to >the >>> >one >>> >>> we have created in Step 2? Or do we use the one >that is >>> >>> first found in the system? >>> >>> >>> >>> --------------------------------------------------- - >-- >>> >>> >>> >>> Looking at the section of "Secure it manually" >>> >>> >>> >>> Can I skip Steps 14-16 as I already have a database >in >>> >my >>> >>> system? Or must I follw these steps and import my >>> >existing >>> >>> database to a new dababase? >>> >>> >>> >>> Sorry to bother you once again >>> >>> >>> >>> Kelvin >>> >>> ---Original Message----- >>> >>> >Kelvin, >>> >>> >The example you found on Joan's website is merely >>> that, >>> >>> an example. You need >>> >>> >to replace the words "path to msaccess.exe", etc. >with >>> >>> the appropriate file >>> >>> >path. In many cases it might end up looking like >this. >>> >>> > >>> >>> >"C:\Program Files\MicrosoftOffice\Office10 >>> >\msaccess.exe" >>> >>> >>> >>>"C:\MyFolder\MyDatabase.mdb" /wrkgrp "C:\MyFolder\MyWork g >>> r >>> >>> oup.mdw" >>> >>> > >>> >>> >These are also just examples and you will need to >>> >change >>> >>> them to fit your >>> >>> >circumstance. >>> >>> > >>> >>> >-- >>> >>> >Lynn Trapp >>> >>> >MS Access MVP >>> >>> >www.ltcomputerdesigns.com >>> >>> >Access Security: >>> www.ltcomputerdesigns.com/Security.htm >>> >>> > >>> >>> > >>> >>> >"Kelvin" <yew_mhis@intr.mhi.co.jp> wrote in message >>> >>> >news:2e8cf01c46d5e$c5489c00$a601280a@phx.gbl... >>> >>> >Hi Joan >>> >>> > >>> >>> >Thanks for your reply once again. >>> >>> > >>> >>> >I managed to find wrkgadm.exe and proceed onto the >>> >steps >>> >>> >as listed in http://www.jmwild.com/security97.htm >>> >>> > >>> >>> >However I am currently facing the problem of >creating >>> >the >>> >>> >desktop shortcut with the following target found in >>> the >>> >>> >above website: >>> >>> > >>> >>> >“path to msaccess.exe” “path to mdb” /wrkgrp >>> >>> >“path to >>> >>> >secure mdw” >>> >>> > >>> >>> >Can you please furthur elaborate on this? How can I >>> >create >>> >>> >this successfully? I am seeing messages saying this >>> is >>> >an >>> >>> >invalid link. >>> >>> > >>> >>> >Thank you and best regards >>> >>> >Kelvin >>> >>> >>-----Original Message----- >>> >>> >>Search your computer for wrkgadm.exe (you are >running >>> >>> >Access 2000, right?). >>> >>> >>Also ensure that you have permission to view all >>> >folders. >>> >>> >> >>> >>> >>Kelvin Yew wrote: >>> >>> >>> Hi Joan >>> >>> >>> >>> >>> >>> Thanks for the reply. >>> >>> >>> >>> >>> >>> I wanted to follow the methods as listed from >the >>> >>> links. >>> >>> >>> However I got prompted an error message when I >was >>> >>> >trying >>> >>> >>> out the first step of typing "wrkgadm.exe" in >the >>> >Run. >>> >>> >>> >>> >>> >>> The error message was "Cannot find the >>> >>> >file 'wrkgadm.exe' >>> >>> >>> (or one of its components). Make sure the path >and >>> >file >>> >>> >>> name are correct and that all required libraries >>> are >>> >>> >>> available" >>> >>> >>> >>> >>> >>> Please help. >>> >>> >>>> -----Original Message----- >>> >>> >>>> Kelvin wrote: >>> >>> >>>>> Hi >>> >>> >>>>> >>> >>> >>>>> The database that I have created is mainly for >>> >public >>> >>> >use. >>> >>> >>>>> However there are some tables which contains >>> >>> >confidential >>> >>> >>>>> information to be accessed by specific users >>> only. >>> >>> >How can >>> >>> >>>>> I tackle this problem? >>> >>> >>>>> >>> >>> >>>>> I see that there are 3 different functinos >under >>> >>> >Security. >>> >>> >>>>> User and Group Permission, User and Group >>> Accounts >>> >>> and >>> >>> >>>>> User-Level Security Wizard. Which one do I >use? >>> >>> >>>>> >>> >>> >>>>> All users are connected to the main server and >>> >each >>> >>> >user >>> >>> >>>>> had been assigned to a password. Is there >>> >anything I >>> >>> >>>>> should look out for? >>> >>> >>>> >>> >>> >>>> There is a lot more to security that just using >>> >those >>> >>> >menu items. >>> >>> >>>> Don't use the wizard in 2000 as it doesn't do >the >>> >job. >>> >>> >>>> >>> >>> >>>> You need to download and study the Security FAQ >>> >>> >available at >>> >>> >>>> http://support.microsoft.com/?id=207793 >>> >>> >>>> >>> >>> >>>> Be sure to follow every step outlined or your >>> >database >>> >>> >won't be >>> >>> >>>> secure. >>> >>> >>>> >>> >>> >>>> I've also outlined the detailed steps at >>> >>> >>> www.jmwild.com/AccessSecurity.htm >>> >>> >>>> >>> >>> >>>> -- >>> >>> >>>> Joan Wild >>> >>> >>>> Microsoft Access MVP >>> >>> >>>> >>> >>> >>>> >>> >>> >>>> . >>> >>> >> >>> >>> >>-- >>> >>> >>Joan Wild >>> >>> >>Microsoft Access MVP >>> >>> >> >>> >>> >> >>> >>> >>. >>> >>> >> >>> >>> > >>> >>> > >>> >>> >. >>> >>> > >>> >> >>> >> >>> >>. >>> >> >>> >. >>> > >> >> >>. >> > > >. >
- Next message: Lynn Trapp: "Re: Change password form without user account info showing"
- Previous message: Lynn Trapp: "Re: Change password form without user account info showing"
- In reply to: Kelvin: "Re: Different Users for Access 2000"
- Next in thread: Joan Wild: "Re: Different Users for Access 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
