Home All Groups Group Topic Archive Search About
Author
29 Nov 2006 7:53 AM
Roger Bell
I have created Passwords through Tools Security with seperate Passwords for
User that can Edit Data and Users that can only view data.  When the user
goes to open the data base, he or she can log on as an editor or Browser,
depending on their classification.  I there any way that the log on Box for
the user name can have a drop down list to save having to type in the user
name every time some one logs on?
Thanks for any help

Author
29 Nov 2006 6:38 PM
accessdesigner
I also have a question regarding passwords but nobody came to my rescue yet,
and I noticed that you at the least have a user log on box... where did that
come from? or did you have to create it? I am trying to create the security
passwords... not sure what i did, but did go through security wizard.. but
cant pull it back up... locked out of my own database system...

Show quoteHide quote
"Roger Bell" wrote:

> I have created Passwords through Tools Security with seperate Passwords for
> User that can Edit Data and Users that can only view data.  When the user
> goes to open the data base, he or she can log on as an editor or Browser,
> depending on their classification.  I there any way that the log on Box for
> the user name can have a drop down list to save having to type in the user
> name every time some one logs on?
> Thanks for any help
Author
30 Nov 2006 1:14 AM
Roger Bell
It is quite complex and can easy be mucked up.  It took me ages and lots of
perserverance.  I was directed to: http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

Show quoteHide quote
"accessdesigner" wrote:

> I also have a question regarding passwords but nobody came to my rescue yet,
> and I noticed that you at the least have a user log on box... where did that
> come from? or did you have to create it? I am trying to create the security
> passwords... not sure what i did, but did go through security wizard.. but
> cant pull it back up... locked out of my own database system...
>
> "Roger Bell" wrote:
>
> > I have created Passwords through Tools Security with seperate Passwords for
> > User that can Edit Data and Users that can only view data.  When the user
> > goes to open the data base, he or she can log on as an editor or Browser,
> > depending on their classification.  I there any way that the log on Box for
> > the user name can have a drop down list to save having to type in the user
> > name every time some one logs on?
> > Thanks for any help
Author
30 Nov 2006 1:22 PM
accessdesigner
the link keeps timing out :-(

Show quoteHide quote
"Roger Bell" wrote:

> It is quite complex and can easy be mucked up.  It took me ages and lots of
> perserverance.  I was directed to:
> http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp
>
> "accessdesigner" wrote:
>
> > I also have a question regarding passwords but nobody came to my rescue yet,
> > and I noticed that you at the least have a user log on box... where did that
> > come from? or did you have to create it? I am trying to create the security
> > passwords... not sure what i did, but did go through security wizard.. but
> > cant pull it back up... locked out of my own database system...
> >
> > "Roger Bell" wrote:
> >
> > > I have created Passwords through Tools Security with seperate Passwords for
> > > User that can Edit Data and Users that can only view data.  When the user
> > > goes to open the data base, he or she can log on as an editor or Browser,
> > > depending on their classification.  I there any way that the log on Box for
> > > the user name can have a drop down list to save having to type in the user
> > > name every time some one logs on?
> > > Thanks for any help
Author
1 Dec 2006 4:31 AM
Roger Bell
Try
http://www.jmwild.com/Accesssecurity.htm

Show quoteHide quote
"accessdesigner" wrote:

> the link keeps timing out :-(
>
> "Roger Bell" wrote:
>
> > It is quite complex and can easy be mucked up.  It took me ages and lots of
> > perserverance.  I was directed to:
> > http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp
> >
> > "accessdesigner" wrote:
> >
> > > I also have a question regarding passwords but nobody came to my rescue yet,
> > > and I noticed that you at the least have a user log on box... where did that
> > > come from? or did you have to create it? I am trying to create the security
> > > passwords... not sure what i did, but did go through security wizard.. but
> > > cant pull it back up... locked out of my own database system...
> > >
> > > "Roger Bell" wrote:
> > >
> > > > I have created Passwords through Tools Security with seperate Passwords for
> > > > User that can Edit Data and Users that can only view data.  When the user
> > > > goes to open the data base, he or she can log on as an editor or Browser,
> > > > depending on their classification.  I there any way that the log on Box for
> > > > the user name can have a drop down list to save having to type in the user
> > > > name every time some one logs on?
> > > > Thanks for any help
Author
30 Nov 2006 4:32 PM
Joan Wild
You can modify the following to have a dropdown for the users names if you
like:
http://www.access.qbuilt.com/html/custom_login.html

--
Joan Wild
Microsoft Access MVP


Show quoteHide quote
"Roger Bell" wrote:

> I have created Passwords through Tools Security with seperate Passwords for
> User that can Edit Data and Users that can only view data.  When the user
> goes to open the data base, he or she can log on as an editor or Browser,
> depending on their classification.  I there any way that the log on Box for
> the user name can have a drop down list to save having to type in the user
> name every time some one logs on?
> Thanks for any help