I'm no expert on SP2, so there may be more than I'm seeing here.
I have heard that it tends to tighten security down "too far" in some
cases.
One of the main problems with file permissions for Access is that in order
to share an Access database, you must have read, write, create and delete
permissions on the folder where the database resides.
I've not heard of that producing the problems you're reporting, but it's a
place to start.
My guess is that you'll have to work with your network administrator to sort
this one out...
- Turtle
"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
Yes, Windows login, if logging in using Windows administrative access
all works fine, otherwise cannot access code...
"MacDermott" <ma********@nospam.com> wrote in message
news:<51****************@newsread2.news.atl.earthl ink.net>...
Are we talking Windows logins here? (when you restart the PC)
Or Access security? (when you start Access)
"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om... I have a database in Access 2002 but I am unable to view code or write
any modules when logged in with a limited user account using Windows
XP, service pack 2 -- no problems when logging in as administrator, --
any ideas on how a limited user on Windows XP can access code and
modules in Access 2002? Thank you very much.