Database is Read Only?

[Savil]

Hi
I have an access 97 front end with SQL 2000 backend. If I am logged on as an administrator everything is fine but when a limited account holder is logged on, the front end throws up a warning saying that the database is read only. the mdb file's properties have the read only box unchecked.
This appears to be an Access generated message and nothing to do with the backend. I avoid Access's own security system like the plague so I fairly sure I have not screwed something up in there.

Does anybody have any ideas

Savil

 

[me2you]

This is obviously a security problem and i advise you check the mdw file associated with your front end.

Peace,

me2you

 

[Savil]

Thanks me2you

The problem was NTFS permissions, the current front end was copied from a development machine on to an XP os machine without the security tab visible which led me to forget about NTFS permissions.

Thanks anyway

Savil