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.