Access doesn't run properly under a restricted user context

[Chuckon]

This is odd and stupid and frustrating. I'm in a domain. A domain user
configured locally as a Restricted User is not able to open a database, see
help, etc. Access can be opened but with every little request it shows an
error like this

"An error occurred and this feature is no longer functioning properly.
Would you like to repair this feature now?"

If the user is an administrator no problems happen at all, whether is a
local or domain administrator.

Any ideas?

 

[Tom Wickerath]

Joseph,

However a simple mistake can lock everyone including God out.

If this is true, please explain how businesses such as lostpassword.com
(http://www.lostpassword.com/access.htm) can survive. In any case, even if Access security once
frustrated our Heavenly Father, it certainly doesn't any longer. That's because He called upon
Cheryl Fischer to join His team.

http://groups.google.com/groups?hl=en&lr=&c2coff=1&th=162e607a084c1c50&rnum=1

Please don't take this as any disrespect to Cheryl or to God. I simply don't think anyone should
be making the implication that Access security is so rock solid....it just ain't so.

Tom
___________________________________


To properly function the user needs full access to the directory(s)
where the database(s) are located. The includes read, write, delete and
create. Assorted problems can come up if this access is not available

Is this database secured using user level security? If so I suggest
you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.


--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

___________________________________


This is odd and stupid and frustrating. I'm in a domain. A domain user
configured locally as a Restricted User is not able to open a database, see
help, etc. Access can be opened but with every little request it shows an
error like this

"An error occurred and this feature is no longer functioning properly.
Would you like to repair this feature now?"

If the user is an administrator no problems happen at all, whether is a
local or domain administrator.

Any ideas?

 

[Tom Wickerath]

Hi Joseph,

...and few people will be able to beat it.

As long as they're not willing to part with $50 or so, and they are working with the JET 4 file
format, I agree that few people, including myself, would be able to crack a properly secured
Access database. I just don't think its fair to leave inexperienced Access users with an
incorrect impression about Access security being so good that it "can lock everyone including God
out". It simply raises the bar.

To be honest, I don't tend to use Access security because it isn't so difficult for others to
break if they are determined enough. I use Windows 2000 folder permissions to determine who
access a shared BE file in the first place. I also distribute only .MDE's with a disabled shift
key and a hidden database window. The users only have reasonable access to the forms and reports
that I make available via an unbound switchboard. Now, I realize that someone can re-enable the
shift key just as easily as I can disable it, unless I go that extra step by setting the DDL
property to True and implement Access security. But, if someone wants in THAT bad--and I learn
who it is--then I simply pay a visit to their manager and have a friendly chat about the
situation. Of course, there are certain things that I'm paranoid enough about, that I simply
won't do in Access, such as store social security numbers (even with Windows security on the
folder).

Tom
____________________________________

Joseph,


If this is true, please explain how businesses such as lostpassword.com
(http://www.lostpassword.com/access.htm) can survive. In any case, even if
Access security once frustrated our Heavenly Father, it certainly doesn't
any longer. That's because He called upon Cheryl Fischer to join His team.


http://groups.google.com/groups?hl=en&lr=&c2coff=1&th=162e607a084c1c50&rnum=1

Please don't take this as any disrespect to Cheryl or to God. I simply
don't think anyone should be making the implication that Access security
is
so rock solid....it just ain't so.

Tom

No argument Tom. I agree that for high security issues Access security
is not good enough, but it is good enough to cause some real problems for
someone not being careful when building it and it is very good, for most
uses and few people will be able to beat it.