My Security in Access 2000

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

Hi,

It sounds like the Access security always has loophole.
What I did to my application is to put the authority in
VB code directly by detecting the window log on name.
Then I run MDE file for users to access the application
so they don't have authority to read my VB code. Since I
don't have many users, the security management is not
much work for me now.

My question is: is this security really secure? Any
better thoughts?

Thanks,

Shirley
 
Shirley said:
Hi,

It sounds like the Access security always has loophole.
Click to expand...

No, it only has loopholes when it is implemented incorrectly. By that I
don't mean that it's not hack-proof (just about nothing is), but when
applied properly it takes a fairly motivated person to break in. If for no
other reason then they would have to purchase the software to hack their
way in.

If what you are talking about is along the lines of ..."All someone has to
do is this and that and they can get in.", then you would be describing an
app where security was not applied correctly.
What I did to my application is to put the authority in
VB code directly by detecting the window log on name.
Then I run MDE file for users to access the application
so they don't have authority to read my VB code. Since I
don't have many users, the security management is not
much work for me now.

My question is: is this security really secure? Any
better thoughts?
Click to expand...

How does this secure the data? Couldn't a user simply open the data file
directly with Access and do whatever they wanted? If you only care about
securing your code, then an MDE is all you need.
 
Back
Top