adewale4favour
Registered User.
- Local time
- , 20:54
- Joined
- Aug 9, 2019
- Messages
- 57
Hi Guys,
Hope we are all keeping safe.....![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
I discovered a major problem with my Access Application and I have been trying to fix it, anyone with tips, will really appreciate it.
I have an access application running from a server with the FE distributed on users table. One very important table linked to every FE is the UserID information. This is where all user Authorization Information is, including UserName Password, Credit Card details(Verification purpose) and other important information.
What I actually discovered is that, when anyone uses EXCEL's POWER query to fetch information from any of the tables, the whole information include very sensitive ones, like the password, username, credit-card details, everything just comes up and this information can be exported to Excel or used.
What I have tried to do was to use the VBA deploying the Access TableDef Object, I noticed that, though the table is hidden by the code, it doesn't stop Excel Power Query or other external data fetching tool from accessing it.
I think there will be a way around this, I have been trying to figure this out, this is not good for any Database Application by any means, as anyone could use this to fetch any sensitive information from the Application.
Anyone with tips to fix this please.
Hope we are all keeping safe.....
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
I discovered a major problem with my Access Application and I have been trying to fix it, anyone with tips, will really appreciate it.
I have an access application running from a server with the FE distributed on users table. One very important table linked to every FE is the UserID information. This is where all user Authorization Information is, including UserName Password, Credit Card details(Verification purpose) and other important information.
What I actually discovered is that, when anyone uses EXCEL's POWER query to fetch information from any of the tables, the whole information include very sensitive ones, like the password, username, credit-card details, everything just comes up and this information can be exported to Excel or used.
What I have tried to do was to use the VBA deploying the Access TableDef Object, I noticed that, though the table is hidden by the code, it doesn't stop Excel Power Query or other external data fetching tool from accessing it.
I think there will be a way around this, I have been trying to figure this out, this is not good for any Database Application by any means, as anyone could use this to fetch any sensitive information from the Application.
Anyone with tips to fix this please.
Last edited: