know for the FE we seam to be fine as long as we only give clients Accde files.Wrong. There are companies that will "decompile" the database to produce VBA code. Earlier attempts produced tokenized code which although it was valid VBA, was very difficult to read because all the variable names were cryptic. Newer tools produce very readable code with meaningful variable names.
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
TRUSTED BY
Keep "amateurs" from accessing your code, queries, table design and relationships.
Also, keep in mind that MS Access isn't designed for puplic deployment (in other words: designed for internal applications).
If you're looking for more robust security, MS Access isn't the tool for you. Look for compiled languages such as .Net, Java, C++ or C, and better database engines like MySQL, SQL Server, Oracle, postGreSQL ect ...