Setting up User Level Security to my Access 2003 database

[latemoy]

When I'm attempting to assign User Level Security to my Access 2003 database,
I get an error message stating:

Error 'An unexpected error occurred while creating the workgroup file.': The
wizard can't complete successfully.

 

[Chris O'C via AccessMonster.com]

Make sure your disk isn't full and you have permission to write files to C:\
Documents and Settings\username\Application Data\Microsoft\Access and the
folder you save your custom workgroup file to if you get this error when
creating custom workgroups.

Check your vba version in C:\Program Files\Common Files\Microsoft Shared\VBA\
VBA6\VBE6.DLL. Mine is version 6.05.1024, dated May 8, 2009 for Office 2003
sp3.

If all seems in order, try to repair Microsoft Access with your Office 2003
cd, then try creating a new workgroup file, joining it and assigning
permissions to db objects.

Chris

 

[Arvin Meyer [MVP]]

When I'm attempting to assign User Level Security to my Access 2003
database,
I get an error message stating:

Error 'An unexpected error occurred while creating the workgroup file.':
The
wizard can't complete successfully.

I've always found that doing it manually gets me the best results. Here's a
host of resources that should help:

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