Question on distributing and securing access database 1

[tmadhavi62]

Hi,
We are developing an access application and want to sit on a common server where everyone can access the database and generate their own reports. I have queries to generate the reports and also tables whose information gets updated every hour.
Question 1: Will the user be able to view and modify the queries and tables? How can I protect the application from getting modified?

Thanks
Madhavi

 

[batteam]

If your tables are in a database by themselves and they're linked, you can simply password protect that database. Users in the application database can still run queries against those linked tables.

If you're worried about someone modifying your VB code behind your applications (forms, etc.), you can make it the application an .mde file (instead of the .mdb file that it is). These are just two brief ideas. There are many more to incorporate, depending on how much experience you have and how solid you want the protection.

Reply if necessary. Good Luck.

 

[vbainchicago]

You might want to disable the shift key also. A lot of users use it to bypass any startup forms you may be loading.

VBAinChicago

http://www.jjscomputing.com

http://www.blueboxshopping.com

 

[psemianonymous]

I wrote a FAQ about what is possible in Access, security-wise. Basically, all your users will be able to edit table and query data. There are steps you can take to obfuscate, making it harder for them to do so, and there are steps you can take (implement built-in Access/JET security setup) that will provides decent security, but nothing will fully protect your data. If you compile the MDB file to an MDE, then they will absolutely not be able to edit your forms or reports, or view your code. Check my FAQ:

Gauging your security needs; alternatives to Access/JET security faq181-3893

 

[tmadhavi62]

Hi all,
Thank you all for your valuable time. My question is should I have all my queries which generate a report in VBA Code or is it okay if i leave them in the queries (where you can design your own). I don't want user to delete these queries by mistake. I have only one database with no linked tables.

THanks,
Madhavi