security!

[bpaquette]

i'm afraid i'm a bit vexed as to how the security features work. I have a database saved on a shared drive accessible by about 6 people. when i log into the database from my pc everythings fine and everybody is happy and i get prompted for a password and woo. however, when i or anyone else logs into the database from another computer, it prompts for no password. did i miss a step in securing the database?

i dont necessarily need it uber-secure, i just need to be able to identify which user is doing what.


regards,

 

[namliam]

Why, if you dont need "uber-secure", not use the windows logon user to track instead of the "shitty" access security??

Regards

 

[bpaquette]

er the only way i can get audit trail to accurately display which user made a chnage is by setting up security, etc. how do i do what you're proposing?

 

[namliam]

Instead of having users log into your DB you can retrieve the windows user name and use that for your audit trail....


In newer versions (XP and 2000 i think) you can use: Environ("Username")
In older versions you need to call an API to get it. I used to have the code for it but dont seem to have it anymore, its available out there ...

Regards

 

[ColinEssex]

I may be wrong, but it seems your after 2 different things.

1) an audit trail

If you do a search for Audit trail, GHudson has posted excellent examples and you can use the login name to see who did what and when.


2) security using the user name

The security can be done by creating a user table and their login names, you can then get the Db to check that the person logging in is a genuine user. If they're not then a message box can appear saying they cannot get in and then logs off the database.
You don't need a password, its all done on the network name checks.

Both subjects have been covered in depth recently. Have a search but post back if you have probs.

Col

 

[bpaquette]

Environ("Username") was exactly what i needed. i updated the audittrail module and it works fantastically now, now i can remove all those pain-in-the-ass securities.


thanks guys!