Access

[Floyd Forbes]

Is there a way to protect my table, query and code in access. I want to
share it with others , but not be able
to make any changes or view any code behind forms.
Can access be compiled?

Floyd

 

[Rick Brandt]

Is there a way to protect my table, query and code in access. I want to
share it with others , but not be able
to make any changes or view any code behind forms.
Can access be compiled?

You can make a separate copy as an MDE and give them that. This locks the
design and prevents design view of Forms, Modules, and Reports. It does
not protect data tables or queries. For that you would need to implement
Access user-level security, a rather advanced topic that can still be
cracked by anyone who wants to pay for the software to do so.