Access security

[lottoman2000]

Hello folks,

I will be creating a program for punch in and out for our employees in
the company using access database. I don't want any of the employees to
be able to view other employees information. Would any of them be able
to hack into the database even though I don't give them admin rights?

Please let me know.

Thanks

 

[lottoman2000]

I am using access 2000.

 

[Bill Mosca, MS Access MVP]

There are lots of third-party software that can list all user names and
passwords in a workgroup. If I can find out the location of the MDW file, I
can get any of the Admins members' user ID and password.

So you see, if you are concerned about employees seeing other employee's
info, you need to use a more secure database such as SQL Server. With that,
you can set up individual views and not expose the tables at all.

If SQLS is not an option, there are ways to code database properties so that
the shift key will not bypass the startup and the database window is hidden
thus giving a little more protection. But it is not hack-proof by any means.

I suggest getting a copy of Real World Access Database Protection and
Security by Garry Robinson. He has a rather unique take on security that
might be tight enough for your needs.