ado connection with other databases

[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

 

[MacDermott]

Before you go into creating an elaborate security system of your own, I'd
urge you to consider the built-in security which Access offers by means of
the mdw file. It's almost certainly more secure than anything you can build
yourself. Especially if you are distributing an mdb file to your users, any
code you put in it will be visible to any users.
Access security is certainly not the last word in security. Crackers
are available with just a Google search. However, if your users are all
internal to your organization, and you have people in your organization who
are willing/likely to hack into your databases, I tend to view that as more
of a HR problem than an IT one.

HTH