Setup read-only user account

[rnooraei]

Hi
I have been told to create a read-only access to Access database for reporting purpose. I learned how to do that using Workgoup Administrator (System.mdw) and create User and Goup Account. Here is my problem
My database has password so when you pass the first level which is User Account it will ask you about DBA password. The problem is I don't want to give the DBA password. How could I do that?

 

[Remou]

If this is for linking tables and such like, you can include the password in code.

 

[rnooraei]

The user wants to use this database for creating their own report, so there is no program.
I also have another problem which when I created my MDW file seems every database I open it will effected by this new MDW. I should say that I create this file in the different directory. (not existing SYSTEM.MDW)

 

[Remou]

You will need to do a little reading. Search the Access FAQ with keyword Security. There is quite a bit to creating MDWs.