Data security of accdb files

[CJ_London]

You are using dao not ado according to your attachment

msysobjects is a system table and not editable

and you opened as a snapshot - and snapshots are not editable

with regards the password - you need to delete the linked table

 

[isladogs]

Hi John
I don't believe that what you showed in the screenshot is my code even if my username is the password.

Posting screenshots of code really isn't helpful.
I can see errors in the code but much easier to correct if you post the code itself.
However, you still need to address all the issues identified by C_J_London. . .

 

[JohnPapa]

You are using dao not ado according to your attachment

msysobjects is a system table and not editable

and you opened as a snapshot - and snapshots are not editable

with regards the password - you need to delete the linked table

You mean delete the links (in the FE) to the tables (in the BE). If this is what you meant, I did delete the links, without success.
Yes, the code is DAO, will try to show the link to the entire issue addressed.

 

[JohnPapa]

Hi John
I don't believe that what you showed in the screenshot is my code even if my username is the password.

Posting screenshots of code really isn't helpful.
I can see errors in the code but much easier to correct if you post the code itself.
However, you still need to address all the issues identified by C_J_London. . .

As I mentioned above I will post the link.

 

[JohnPapa]

As I mentioned above I will post the link.

This is the link which shows everything,

Why MS Access isn't a Secure Database | DEVelopers HUT

MS Access security is questionable and here is why.

www.devhut.net

 

[isladogs]

As I thought, the code wasn't mine.
I did respond to that thread at DevHut showing how to make Paulo's code run without error.
You should be able to see the error in your code from the screenshot in post #85
However, its not an approach I've ever used in practice. At best, it offers minimal additional security

EDIT
Just to add, 85 posts in, I'm still not clear what/who exactly you are trying to secure your app against. I've asked at least once earlier in this very long thread, but don't believe you ever answered the question clearly