User Login ID

[Mellissa via AccessMonster.com]

Hello,

I am trying to create a User Login ID but have no idea how to do it.

I want my database to eventually be able to log the users name that modified
a record and also the date it was modified.

Is there anyway to create a user login and password as soon as the database
is opened, before the processer gets to the Switchboard?

Thank you,
Mellissa

 

[Douglas J. Steele]

Can you simply use their Windows Network ID? If so, check
http://www.mvps.org/access/api/api0008.htm at "The Access Web".

Even if you implement Access User-Level Security (ULS), so that they're
forced to log into Access before using the application, you'll still have to
put code in the BeforeUpdate event of each form to ensure that the user name
(which will be CurrentUser() if you've implemented ULS) and modified dates
are populated before writing to the table.

 

[Guest]

This is called user-level security. Look it up in the help you'll find tons
of info.

The following should help as well,

http://office.microsoft.com/en-us/access/HP030704101033.aspx
http://databases.about.com/od/tutorials/ss/usersecurity.htm

 

[Mellissa via AccessMonster.com]

Hi,

I tried to set the security and put login ids on my database by using user-
level security wizard and now everything I try to open says that I dont have
permission to open it or do anything with it....this is not good. I have
tried to change the permissions, but then it says that I do not have
permission to change the permissions.

HELP !! Please.

Thank you,
Mellissa

This is called user-level security. Look it up in the help you'll find tons
of info.

The following should help as well,

http://office.microsoft.com/en-us/access/HP030704101033.aspx
http://databases.about.com/od/tutorials/ss/usersecurity.htm

Hello,

[quoted text clipped - 8 lines]

Thank you,
Mellissa

 

[Joan Wild]

You don't mention the version, but recent ones create a desktop shortcut to open the secure mdb with. Use that to open the mdb.

--
Joan Wild
Microsoft Access MVP

Hi,

I tried to set the security and put login ids on my database by using user-
level security wizard and now everything I try to open says that I dont have
permission to open it or do anything with it....this is not good. I have
tried to change the permissions, but then it says that I do not have
permission to change the permissions.

HELP !! Please.

Thank you,
Mellissa

This is called user-level security. Look it up in the help you'll find tons
of info.

The following should help as well,

http://office.microsoft.com/en-us/access/HP030704101033.aspx
http://databases.about.com/od/tutorials/ss/usersecurity.htm

Hello,

[quoted text clipped - 8 lines]

Thank you,
Mellissa

 

[Keith Wilby]

Hi,

I tried to set the security and put login ids on my database by using
user-
level security wizard and now everything I try to open says that I dont
have
permission to open it or do anything with it....this is not good. I have
tried to change the permissions, but then it says that I do not have
permission to change the permissions.

HELP !! Please.

Thank you,
Mellissa

ULS is a complex topic and as you've found, you can easily come unstuck.
The wizard is a false economy because it does things without telling you and
you gain no appreciation of ULS and how to fix it when things go wrong.
However, it *should* have made a backup of your original file when you ran
it. It will have a .bak file extension AIUI, so search for that.

If you want to learn ULS then there's a link to the FAQ on my website along
with a step-by-step example.

HTH - Keith.
www.keithwilby.com