I'm just using the Access security as I am still new to Access and it's functions. I've taken a look at this DB Tobi and I have a couple of questions: How do you set up what the users can or can't see/edit? I noticed that when I set myself up as Administrator it allowed some things but not others but I couldn't find (or maybe I'm not recognizing) where you set up those rules.
Also, you have an ActiveXCtl76 on one of your forms and I was wondering what it does. Thanks for your help. --- In AccessDevelopers@yahoogroups.com, "Tobi Hoffman" <[EMAIL PROTECTED]> wrote: > > I put up a file, AccessLoginDBs.zip, in the Demos and Sample Files section a > few years ago with code to log in users. The Access security has too many > pitfalls and problems, so I only used it in one job way back years ago. > > Tobi > > _____ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Carl Beck > Sent: Wednesday, December 21, 2005 2:49 AM > To: AccessDevelopers@yahoogroups.com > Subject: RE: [AccessDevelopers] Security > > > > How do you have it secured? Your own code or Access User permissions. > > User permissions utilizes a MDW file on the local machine unless otherwise > directed, if the file is not there then the db might not be secured. > > If you are using SQL as the backend then what security is being used there > SQL or NT? > > Access always calls the system.mdw file located in the root dir. If you set > the permissions on your machine then move it those permissions don't move to > the new machine. > > I find it is best to create a self contained user permissions table as well > as a log in form. > > Someone has a sample up for download somewhere I just don't remember where. > > > > Carl > > > > _____ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Jose Luis Jr Mora Jr > Sent: Wednesday, December 21, 2005 12:59 AM > To: AccessDevelopers@yahoogroups.com > Subject: Re: [AccessDevelopers] Security > > > > Are you having the users go through the MDW file? > > Elena <[EMAIL PROTECTED]> wrote: > > Hi all. Thanks for the help on the counting days question now I have > another. > > I have created users for my DB and am ready for folks to try it out. > The problem is when they open the program on their computers (the file > is in a shared network drive) they are not prompted for user name and > password. When I open it on my computer it works just fine. Is there > something else I have to do in order for the users to be prompted? > > Thanks!! > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > SPONSORED LINKS > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+developer&w1=Microsoft > +access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa se&w4=M > icrosoft+access+training&w5=Microsoft+access+training+course&w6=Micro soft+ac > cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> access developer > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+help&w1=Microsoft+acce > ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4 =Micros > oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ access+ > programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access help Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas e&w4=Mi > crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros oft+acc > ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> access database > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+training&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas e&w4=Mi > crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros oft+acc > ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> access training > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+training+course&w1=Mic > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+ databas > e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6 =Micros > oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A> access > training course Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+programming&w1=Microso > ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+data base&w4 > =Microsoft+access+training&w5=Microsoft+access+training+course&w6=Mic rosoft+ > access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> access programming > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ > ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
