access file protection from unauthorised copying/saving etc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I run an access sales datebase (Access 2000) in a small company where many people have to have accessto the file.
How can I prevent anyone from copying the file to disc, e mailing it out, saving as another file, in other words preventing anyone from stealing it?? Not sure if this is more of a general problem with all computer files but maybe Access can 'look after itself'??
 
In my view, if you have a problem with company employees stealing your
files, that's an HR problem more than an IT problem.
If you have serious concerns about tech-savvy outsiders getting your data,
Access will never offer you the level of security you'll get with something
like MySQL or Oracle.

You can secure your Access database from non-savvy outsiders by applying
Access Security. This won't keep them from stealing the file, but it will
make it a lot harder for them to read it once they get it.
Of course if it's insiders who know the logins and passwords, it won't be as
hard for them... (back to the HR vs IT comment at the top.)

HTH
- Turtle


Whitney said:
I run an access sales datebase (Access 2000) in a small company where many
Click to expand...
people have to have accessto the file.
How can I prevent anyone from copying the file to disc, e mailing it out,
Click to expand...
saving as another file, in other words preventing anyone from stealing it??
Not sure if this is more of a general problem with all computer files but
maybe Access can 'look after itself'??
 
Besides what MacDermot said, if you are limited to use MS Access and you are
technically capable, you may consider to build an intranet ASP web
application. This way, the users only access to the data through web
browser, while the *.mdb file can be located on a server computer somewhere
not easily accessible to everyone (in a locked closet of your office,
maybe?).

Whitney said:
I run an access sales datebase (Access 2000) in a small company where many
Click to expand...
people have to have accessto the file.
How can I prevent anyone from copying the file to disc, e mailing it out,
Click to expand...
saving as another file, in other words preventing anyone from stealing it??
Not sure if this is more of a general problem with all computer files but
maybe Access can 'look after itself'??
 
Norman,
Thanks very much for your help. I'm not sure how you set this intranet application up, so I will need to find out, although this does seem to be an excellent answer to my problems, thanks. Can you point me in the right direction??
 
If you have some programming knowledge/experience, ASP application on
intranet is fairly easy to build; while if your skill is limited on MS
Access, you can look at MS Access Data Access Page (Access 2K or later).
With Data Access Page, you do not need other tools.


whitney said:
Norman,
Thanks very much for your help. I'm not sure how you set this intranet
Click to expand...
application up, so I will need to find out, although this does seem to be an
excellent answer to my problems, thanks. Can you point me in the right
direction??
 
Back
Top