@isladogs
dear @isladogs , i have red your article http://www.mendipdatasystems.co.uk/improve-security-2/4594571073 very carefully and it helped me very much improving security of my app .
in this thread and in my case i would like to focus on point number( 8. Split your database ) , i have done my app with the same idea long time , i have made a Frontend app for the users and Backend database and placed it in a separate PC on the network and shared the folder (read/ Write) then linked tables to this backend database .
now the issue here is that this shared database folder is at risk by all means because of the below:
- Anyone can access the shared folder network easily by the people who have Curiosity and like to surf the LAN looking for shared folders and see what is in it.
- The shared folder is read and write , so any one can copy or delete the database itself
- Modifying the tables in shared database (in my case i leave the backend database unlocked as accdb or mdb coz i keep updating tables with new fields or adding new tables based on the business requirements) , which risk the database to be stolen or modified by unauthorized persons .
the big questions is:
-how to secure the network folder that contain my backend database?
- is there is a way to hide the shared network folder from being seen by unauthorized employees and keeping it accessible to the linked front end ?
-can we protect the shared folder by password and programing the frontend by vba to enter the password LAN automatically when we run the frontend without giving the password to the user to acces t he shared folder?
- is there is any other ideas to secure the database over LAN other than hiding it? i was thinking about SQL server but it is something i need to study well before i go on with it.
maybe the solution is easier than i think but my mind cant reach it , hope the community here help
thank you
dear @isladogs , i have red your article http://www.mendipdatasystems.co.uk/improve-security-2/4594571073 very carefully and it helped me very much improving security of my app .
in this thread and in my case i would like to focus on point number( 8. Split your database ) , i have done my app with the same idea long time , i have made a Frontend app for the users and Backend database and placed it in a separate PC on the network and shared the folder (read/ Write) then linked tables to this backend database .
now the issue here is that this shared database folder is at risk by all means because of the below:
- Anyone can access the shared folder network easily by the people who have Curiosity and like to surf the LAN looking for shared folders and see what is in it.
- The shared folder is read and write , so any one can copy or delete the database itself
- Modifying the tables in shared database (in my case i leave the backend database unlocked as accdb or mdb coz i keep updating tables with new fields or adding new tables based on the business requirements) , which risk the database to be stolen or modified by unauthorized persons .
the big questions is:
-how to secure the network folder that contain my backend database?
- is there is a way to hide the shared network folder from being seen by unauthorized employees and keeping it accessible to the linked front end ?
-can we protect the shared folder by password and programing the frontend by vba to enter the password LAN automatically when we run the frontend without giving the password to the user to acces t he shared folder?
- is there is any other ideas to secure the database over LAN other than hiding it? i was thinking about SQL server but it is something i need to study well before i go on with it.
maybe the solution is easier than i think but my mind cant reach it , hope the community here help
thank you
Last edited: