Read Only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 02 Mar 2006 17:55 GMT

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?

Reply to this Message

George Nicholson - 02 Mar 2006 21:20 GMT

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,

Signature

George Nicholson

Remove 'Junk' from return address.

>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
[quoted text clipped - 5 lines]
> extensive
> security?

Reply to this Message