MS Access Security Help

G

Guest

Can anyone point me in the right direction for good information / resources
in setting up the security in a MS Access 2000 database file? I have found
out that security is one of the most complicated or confusing issues of MS
Access.

I have a single mde file that I will use. I want to be able to distribute
it without allowing any user to get to the database window. Everytime I use
the Security wizard I either cause it to deny access or it prompts me for a
password. Which I do not want the end users to put in a password. I know how
to use the cmd line switches. It is just the MDW file and setting up the
user permissions that is the big problem.

Any links to resources on the Net or purchasing books is much appreciated.
I think I am looking for a step step walk through.

Seriously Unsecured,

Bob
 
G

Guest

C

Chris Mills

I observe that "Jeff Conrad MVP", not only posts on his web-site how to break
mde's, but is also associated with a company which offers to directly break
mde's.

I think it is unbecoming of Jeff, and certainly unbecoming of an MVP, to post
"How-To's" on breaking MS-Access security, at the same time as purporting to
give advice on how to secure one.

In particular, Jeff failed to advise Bob that, according to Jeff, Bob's mde is
made pointless by Jeff's own mouth and company associations.

Concerned,
Chris Mills
 
T

TC

Personally I can not see anything ethically all that wrong with
decompiling MDEs. (Not that I am necessarily convinced by QB's claims
in that regard.) MDEs were created (afaik) for efficiency reasons (ie.
no decompiled state), not security. It's just that they have become a
convenient means of code security, given the absence of decompilers.
Decompiling an MDE seems, to me, to be a lesser offence that releasing
a general purpose "desecure mdb" tool - which afaik, Jeff has not
proposed to do.

Not wishing to start an argument here; just my 2c.

TC
 
C

Chris Mills

Are you not aware that reverse engineering is universally illegal? Pick up the
nearest License Agreement you can find.

TC says hacking is OK !
 
C

Chris Mills

I have lodged a formal complaint with Microsoft about Jeff Conrad's site (not
about Jeff Conrad exactly).

Who knows if Microsoft will take any notice. I am posting this just so's
no-one thinks I am doing "dirtys". I might or might not post the full text of
my complaint to Microsoft, but it seems inappropriate at the moment (it was
not written as an "open letter").

Probably the first time any such complaint has been attempted. And some people
accuse me of not being serious.

My concern is security in the overall sense. I await with interest Microsoft
reply, if any. The silence in this so-named newsgroup about matters of
security is, well, "crushing".

Chris Mills
Access Developer
 
L

Lynn Trapp

Are you not aware that reverse engineering is universally illegal? Pick up
the
nearest License Agreement you can find.
Click to expand...

hmmmmmmmm... Let's see. If a company owns a database and all the source code
behind it, and they lose (because of accident or corruption or any other
reason) the development version, and they hire a company like QBuilt to
reverse engineer the database so they can have a new development copy, I
would not think that is illegal. I don't know much about QBuilt, but I would
dare to say that that is the kind of service they are offering.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
L

Lynn Trapp

T

Tony Toews

Chris Mills said:
I observe that "Jeff Conrad MVP", not only posts on his web-site how to break
mde's, but is also associated with a company which offers to directly break
mde's.
Click to expand...

Big deal. AFAIK those utilities only get back the forms and reports
with controls. No code though. In my solutions code is about 90% of
the solution so that's of no concern to me.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Tony Toews

Chris Mills said:
I observe that "Jeff Conrad MVP", not only posts on his web-site how to break
mde's, but is also associated with a company which offers to directly break
mde's.
Click to expand...

Also I've posted links to one or two of those web sites at least once
or twice.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Access Security 1
Acc2007 Now Looking for MDW File 0
User Level Security Enquiry 1
Access security behavour 3
IGNORE SECURITY! 1
Linking to a ".mdb" database table via an ".accdb" database 1
User and Group Security 1
Is it possible to create an MDE from an Access 2000 DB with ULS 3

Top