Gthebigt,
I usually find that threatening to break their legs works pretty well.
Failing that, I guess the general principle here is to design your
application in such a way that they can only edit data that they are
allowed to. I assume that the sales people are using a different
computer than you? If so, one approach is to make two frontend files,
one for you and one for them. On theirs, you will only use forms that
provide access to the data that is relevant to them. First of all, you
will restrict it by excluding any tables and fields that are not
relevant to them. And then you can restrict it further, in the case of
data that they need to be able to see but not change, by one of two
general approaches... First by setting as applicable, the
AllowAdditions and AllowEdits and AllowDeletions properties of the
forms. Second by setting as applicable, the Enabled and Locked
properties of the individual data controls on the forms.
