Access 2003 says unsafe expressions not blocked, but only some users on same computer

[ZLA]

We installed Microsoft Access 2003 on Windows Server 2008 Standard. When I access the server using an administrative user, I can open my Access database without any problem whatsoever.



But when I log in with a non-administrative user, I get a bunch of messages about blocking unsafe expressions. The complete list of errors are:

---------------------------------
Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions? [I select NO]

Security Warning: Unsafe expressions are not blocked. To block unsafe expressions, Microsoft Jet 4.0 SP 8 must be installed. ... Do you want to open this file? [I select YES]

Opening "MyDB.mdb": This file may not be safe... Do you want to open this file? [I select OPEN]

The database "MyDB.mdb" is read-only.
--------------------------------------------------

I search for the Jet 4 SP 8 and didn't find it so I don't believe it is loaded. But since it isn't requried for the admin user, I don't see how it is the problem. Also, MS documentation suggests that you need to install SP 8 in order to block expressions, which I don't want to do. This is a database that has been running on Windows Server 2003 for 7 years now. We just want to use it on our new Windows 2008 server.

What do I need to do to let the application run without errors and not read-only?

Thanks.

[Matrix]

We have a very active forum dedicated to Access, you may want to post your question there.

[ZLA]

That's good to know. I found the answer though. Issue was two-fold:

1) macro security level set differently between admin user and non-admin user. don't know why since I never set this for either user.

2) non-admin user didn't have rights to mdb folder which prevented ldb file from being created, thus "read-only"

[Matrix]

Glad to know you have sorted it out. Thanks for your posing your solution!