SQL Server – Is Connecting MS-Access Front End to SQL Server Back-End a Security Breach?

ms accesssql server

I have a MS Access frontend that I would like to install on 5-7 computers, so they can access a SQL Server stored on a shared network drive:

enter image description here

If possible, is it safe and can my data be corrupted? Otherwise, how I have 5-7 users access the SQL Server simultaneously by using an interface?

Thank you very much for your time!

Best Answer

If they have access to the tables directly with insert, update and/or delete rights then they can corrupt your data. If you prevent this by limiting the access-rights or by an MS-Access application then they can/should not be able to corrupt your data.

About business rules. According to Wikipedia: A business rule is a rule that defines or constrains some aspect of business and always resolves to either true or false.. These rules can be defined in the database as constraints but are more often checked by an application. For example a company can give a discount to a customer only in special cases. Or a client can only be deleted if it has no outstanding payments. If the business rule is checked by an application then giving somebody access directly to the tables with update and/or delete rights can corrupt your data.

Related Question