Hi,
I will be distributing my FE db no late than Monday morning to the users.
I can not distribute ACCDE file because I build the db in 2013 but all other users use 2010 and ACCDE file from 2013 is not compatible with 2010. Converting the file in ACCDE by opening the db in 2010 is also not working.
So I am compacting the FE db and doing the following prior to distribution, please let me know if there is anything else I should do to protect the file. I am not too too much concerned about security. Its a group of 15 people who will be using the db
1. Map tables from FE to BE
2. Put the code to minimize access application
3. Put vb code to protect deletion of tables
4. Hide navigation pan
5. Disable f11 key. I did this by going to 'options' and unchecking 'Use Access Special Keys'.
6. Password protect the vb code
7 Hide ribbon by going to 'options'...
Anything else?
Also, do I need to protect BE as well. The users will need to have permissions too access the tables so I am assuming I cant protect it too much.
Thank you
I will be distributing my FE db no late than Monday morning to the users.
I can not distribute ACCDE file because I build the db in 2013 but all other users use 2010 and ACCDE file from 2013 is not compatible with 2010. Converting the file in ACCDE by opening the db in 2010 is also not working.
So I am compacting the FE db and doing the following prior to distribution, please let me know if there is anything else I should do to protect the file. I am not too too much concerned about security. Its a group of 15 people who will be using the db
1. Map tables from FE to BE
2. Put the code to minimize access application
3. Put vb code to protect deletion of tables
4. Hide navigation pan
5. Disable f11 key. I did this by going to 'options' and unchecking 'Use Access Special Keys'.
6. Password protect the vb code
7 Hide ribbon by going to 'options'...
Anything else?
Also, do I need to protect BE as well. The users will need to have permissions too access the tables so I am assuming I cant protect it too much.
Thank you