Read Only

[Guest]

I have a linked database, FE and BE. Is it possible to view the BE data
using the FE interface while making the BE data read only. If I make the FE
Read only, the users can still make changes to the data because just the FE
is read only. In other words, I want the users to open the FE and only be
able to view the data, not make changes. Is this possible without extensive
security?

 

[George Nicholson]

Here is one general approach:
Set the AllowEdits, AllowDeletions, AllowAdditions and DataEntry to False on
all of your FE forms.

Next: make sure the only route that users have to the data is through those
forms: 1) make sure the database window is unavailable (Tools>Startups). 2)
Disable Special Keys (Tools>Startup). 3) Disable the Shift key (VB Code -
making sure you know how to re-enable it. Read that as: build yourself a
back door).

Having said all that, if someone knowledgeable enough really, really wanted
to get around all this, they could. Access can never be 100% secure. (You
won't see the CIA using it.), but this should prevent the vast majority of
any "casual" or even "power" users from being able to make data changes via
the FE either accidently or intentionally.

Now, what if they navigate to and open the back end file directly?

HTH,