Is there a way to set a password for the forms and tables so they cannot be changed but, leave full access to the reports so the reports can be changed?

Put the reports in a separate front end mdb file, put the forms in another
separate front end mde file and put the data in SQL Server with appropriate
permissions according to user.

Anybody can edit the reports, nobody except developers who have access to the
original mdb front end for the forms mde file can edit the forms and read
only data users will have to log in with different user name and password if
they want to edit data, so SQL Server needs to use mixed mode security.

You can add a db password to the forms mdb so only developers can open it,
but that's not very secure.  It's best to leave dev files in a dev folder
only developers have Windows access to.

Chris


James wrote:

BE/ FE Question
vba opendatabase readonly
record level lock access 2002
can't disable shift key with faq_DisableShiftKeyBypass function
ACCDE
Forgotten password and reloading Access
RWOP and passing variables to a function
Change Ownership of Database Object (?)
Maintaining and updating Access 2007 database
fastest way of distributing a split and secured database