Hi All,
Firstly, I am aware from reading previous posts that if someone is
determined enough, they will crack an Access Application. However, this
problem seems basic but I can't find a workaround.
I have a frontend/backend database at work which contains some
sensitive information. I have used Access security along with my own and
have disabled the shift key at start-up. I thought this was quite secure
but I have found that someone has hacked into it and given themselves
administrator privileges within my own security. After a lot of
investigation, I have found out that they have done this by creating a
new database under my workgroup and then importing the tables from the
frontend. They can then open up any table they please and have
visibility of everything due to no form being set to start-up..
I have changed the way my security works by splitting the user table
down so that the permissions given to each user is split from their
passwords which they can change and given them only read permissions.
What I want to be able to do is stop people being able to import/link
from either the FE or BE unless they are the administrator. I have spent
hours looking through the help files but can't see any reference to
this.
I am using Access 2002 SP2 on a XP platform.
TIA