Data security; how to?

[Niebotel]

I have created a front-end/back-end application in Access 2007. The application will be distributed to several users.
I want to prevent that users will directly look into the tables. If I add a database password I have to give that password to the users so they can still via access directly see the tables in then backend. How to solve this problem?

Thanks on forehand for your suggestions!

Willem

 

[MichaelRed]

just place hte password in the code which accesses the BE. It can be more or less complicated, depending on how you normally access the data. In general, if you use url addressing for the data, then you need to only access the specific recordsets required for each function (Form / report ... ) which the users may instantiate. The code gets to be somewhat more cumbersome / voluminous, but hte overall security is (in my opinion) better.



MichaelRed

 

[Niebotel]

So I have to set the password on the backend? OK I understand but....
In the frontend I retrieve the data in several ways:
1. ACCESS queries for forms and reports
2. VBA for the more complicated things; I use for that part ADO.
How to set passwords for these two ways of working?