S
SalimShahzad
Dear Gurus,
I have various access database for various purposes. but all are link
with userid table which keep stores every user info and keep tracking
event or actions perforn. currently i used LINK TABLE method. that
feels me very unsecure as any one can connect and get userid/password
of our all networks enviornment from system.
now i am seeking for advice any way that i can connect using
ado/vba(prgramaticlly) that login/auditing database, i open connection,
then pass values into it then while exiting database from any location
it will close connection or once it do entry then close. But during the
time user keep connected databases remain live and whatever the actions
performs it stored in login/auditing database.i keep store userid as
global variable that can be access any part of access in production
databases.
if i do everything programaticaly and pu VBA password. then also put
password on open access of login/auditing database can make much secure
than current above LINK TABLE SCENERIO.
Thank you in anticpation.
Regards,
Salim Shahzad
I have various access database for various purposes. but all are link
with userid table which keep stores every user info and keep tracking
event or actions perforn. currently i used LINK TABLE method. that
feels me very unsecure as any one can connect and get userid/password
of our all networks enviornment from system.
now i am seeking for advice any way that i can connect using
ado/vba(prgramaticlly) that login/auditing database, i open connection,
then pass values into it then while exiting database from any location
it will close connection or once it do entry then close. But during the
time user keep connected databases remain live and whatever the actions
performs it stored in login/auditing database.i keep store userid as
global variable that can be access any part of access in production
databases.
if i do everything programaticaly and pu VBA password. then also put
password on open access of login/auditing database can make much secure
than current above LINK TABLE SCENERIO.
Thank you in anticpation.
Regards,
Salim Shahzad