User login

[Jeremy Corson]

At one point of my development of this database, I had set up user names and
logins by using the features that were built into Access. I beleve it was
calls user-level security. Which worked great untill i went "live" with my
program and realized that not only does this user-level security utility
secure just my Database but every database you go to log into. This creating
multi log-in for other databases we have. Granted this could be "new
programer error". HAHA. So in a last ditch fix for this i removed the login
and just set each person front end to default to there user name so that it
at least is attaching their name to their record they create. Obviously i
want to have them login but after reading though other post i have found, i
have learned that it's to time consuming to "recreate the wheel" as it were
put. My question is what should i do? It doesn't come down to a question of
secuirty, but i just want to beable to log users activity. Suggestions
please. Thanks guys

 

[Tom Wickerath]

Hi Jeremy,

My question is what should i do? It doesn't come down to a question of
secuirty, but i just want to beable to log users activity.

You just need to use code to read the NT User ID at startup. You can call
the function in an Autoexec macro, and store the result in a global variable.
Then timestamp records accordingly, wth the User's NTUserID and perhaps the
Date / Time:

Get Login name
http://www.mvps.org/access/api/api0008.htm

Oh, and on the security problem, you can avoid this by not permanently
joining to a customized workgroup information file (*.mdw). Instead, you can
specify a custom .mdw file in a shortcut. However, it sounds like you really
don't have the need for ULS.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Vinayak N]

Hi Jeremy,

Security is a very good feature and it would affect just the one
database that you apply it for. A separate .mdw file by default called
secured.mdw would be created which would be necessary for logging into
the particular database on which security has been applied.

- There is an option while applying security on the database where it
says: 'Create a new workgroup file' or 'Modify my current workgroup
file'; be sure that you are using the Create new option.

- Also next you would have options 'I want to make this my default
workgroup information file' and 'I want to create a shortcut to open my
security enhanced database'. Be sure to select the SECOND OPTION.

The shortcut that would be created would be placed on your desktop. If
you check the target information of the shortcut you would find it to
be in the following format:

"location of MSACCESS.EXE of your machine" "path of the database"
/WRKGRP "path of the secured.mdw file"

Now if you want the same secured database to be accessible to all the
other users on the network just make appropriate changes in the
shortcut. eg. change the location of msaccess.exe in the shortcut which
would point to their respective msaccess.exe.

Hope this information is of some help to you.

Regards,
Vinayak

 

[Sandy]

This is good if you are using a form or macros. My problem is bigger. My
boss insisting in share the Admin rights. I am tired of objects being
changed without my knowledge. He bypass at startup. How do I track his
activities?

 

[Tom Wickerath]

Hi Sandy,

If this is something your boss wants to do, and you value your continued
employment at this place of business, then perhaps you should just let him
have his way.

My boss insisting in share the Admin rights.

You haven't stated whether or not you are using the built-in ULS (User Level
Security). Is that what you mean by Admin rights, or is he logging into the
PC as Administrator?

He bypass at startup.

At the risk of pissing him off, you could try disabling the Shift Bypass
key. Access MVP Albert Kallal has a ready made Access DB for you. See the
download for "By Pass Shift Key Code", available here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Create a switchboard form, set it as the startup form, and then compile your
app. to the .mde format. Disable the Shift Bypass key with Albert's code.
That should keep your boss out, but it may also result in your starting an
unplanned search for new job.

Good Luck,


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

This is good if you are using a form or macros. My problem is bigger. My
boss insisting in share the Admin rights. I am tired of objects being
changed without my knowledge. He bypass at startup. How do I track his
activities?

__________________________________________

:

Hi Jeremy,

My question is what should i do? It doesn't come down to a question of
secuirty, but i just want to beable to log users activity.

You just need to use code to read the NT User ID at startup. You can call
the function in an Autoexec macro, and store the result in a global variable.
Then timestamp records accordingly, wth the User's NTUserID and perhaps the
Date / Time:

Get Login name
http://www.mvps.org/access/api/api0008.htm

Oh, and on the security problem, you can avoid this by not permanently
joining to a customized workgroup information file (*.mdw). Instead, you can
specify a custom .mdw file in a shortcut. However, it sounds like you really
don't have the need for ULS.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________