Access 2003 & User Level Security

[time_racer via AccessMonster.com]

Hi,
I am trying apply the user level security for my tables, forms, reports and
Macros. I looked to some threats here and most of them are talking about
access2000 or 97 but not 2003.

Also I tried to create the group which has a limited access to the tables and
forms but while creating the usernames along with their passwords in the
security wizard it showed me this message:
¨
The expression On Click you entered as the event property setting produced
the following error: Microsoft Office Access can´t move the focus to the
control tbUserName.

* The expression may not result in the name of a macro, the name of a user-
defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro
¨
However it allows me to continue the wizard and when finished, another error
showed saying:¨
Error ´An unexpected error occurred while creating the workgroup file.´: The
wizard can´t complete successfully.¨

I hope if someone can assist me on this, BTW this is my first time to apply
user level security depending on wizard

 

[Arvin Meyer [MVP]]

Just a guess. Is tbUserName a visible control? You cannot set focus to a
control that's either not visible or not enabled. This should address most
of your security questions:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm