Dear colleagues ,
Im developing an accounting system for 1 of my client the problem im facing is how to secure the access database file to avoid unauthorized access and manipulation so only the accounting system can use the database ,and idea to help me are highly appreciated . all the best .
Comments
:
: Im developing an accounting system for 1 of my client the problem im
: facing is how to secure the access database file to avoid
: unauthorized access and manipulation so only the accounting system
: can use the database ,and idea to help me are highly appreciated .
: all the best .
:
Most database systems include functions to encrypt the data they store. This way the user is asked to give a password to decrypt the data. It won't stop other programs from accessing the data, but it should stop unauthorized people from reading the data contained within the database (at least for a while)(depending on the encryption strength).
: :
: : Im developing an accounting system for 1 of my client the problem im
: : facing is how to secure the access database file to avoid
: : unauthorized access and manipulation so only the accounting system
: : can use the database ,and idea to help me are highly appreciated .
: : all the best .
: :
the way to protect an access database is by using workgroup security. this will require creating users/groups with individual accounts and passwords, and permissions for the database objects [read/update/insert/delete, etc]. the information is stored in the 'system.mdw' file. you will want to search online for the proper methology to secure the database as it involves a number of steps and is somewhat involved.
encryption adds an additional level of security; however, at the expense of overhead that will reduce database performance. I personally don't use encryption due to the performance hit.