Security

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

One last question on this: This is really the only issue
I have with Access....everything else is fine:

I am trying to keep people from what I would call
backdooring my database. ie Opening another database and
exporting from my database and / or writing to my
database, or from my database from another database. I
have deactivated the bypass key but that does nothing for
this critical issue.

I cannot password the whole database becsuse it is a
multiuser application and I would have to give everyone
the password anyway.

From what I am reading workgroups do not handle
this "backdooring" either.

Is buying one of the third party encryption softwares I
have seen on the internet a good solution?

Thanks,

Douglas
 
Sure you can do that with user-level security. *Every access* to the
back-end tables, must be done through so-called "Run With Owner Permission
(RWOP)" queries. If this is set up properly, your users will only be able to
view the data, by using the proper forms & reports. They will >not< be able
to access the tables directly.

But this is a fairly advanced feature of Access security. You'd need to be
well familiar with the other aspects, before you went down this track.

HTH,
TC
 
Back
Top