protecting split database

[Troy]

I created a master copy of my database before splitting
it. Once I split it I was successful in placing a copy of
the frontend on each pc and relinked all the tables.

The question I have is how, if possible, can I protect the
tables on certain work stations from editing the data? I
only want them to view the data and not edit it.

Thanks in advance!

Troy

 

[Allen Browne]

The simplest approach may be to create 2 front ends: one for those with full
power, and the other with its forms set to read only.

Alternatively, you could lock the forms, and provide some kind of interface
to unlock them.

You could also implement Access security, but that is probably overkill for
what you need.