access file protection from unauthorised copying/saving etc

[Whitney]

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'??

 

[MacDermott]

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

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'??

 

[Norman Yuan]

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?).

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'??

 

[whitney]

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??

 

[Norman Yuan]

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.

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??