Linked tables do not display password in MySysObjects
Security issue in Linked Tables (FrontEnd to BackEnd)
4
votes
Alvaro Teixeira
shared this idea
2 comments
-
Alan Cossey
commented
I would suggest you don't save the password. It is better to run a connection to the back end when you start up your app, e.g. by using OpenDatabase (with an Access back end) or a SQL pass through query (if an ODBC back end). This creates a cache which is then automatically used by linked tables so they will then connect.
-
Matthias Laux
commented
This is a big security issue.
With
Set curDb = OpenDatabase("C:\Path\xxxxxx.accde")
Set rs = curDb.OpenRecordset("Select Connect From MSysObjects Where Connect Is Not Null")
While Not rs.EOF
.......
we can easily read tables and password from DB
Please, fix it