Permission to a User

[Waheed2008]

Hi all,
I have got a problem in Access. I am using Access 2003 and have developed a Database for my company. Now some other user will be using this Database for data entry. I want that other users should be allowed to Insert-Update-Delete records and should not modify/alter database structure or component.

I have tried a method of creating new group and user but these settings are not attached with db file. As when I open db on some other computer no setting is applied.

Can any body tel me what is the solution of my problem? Any help will be highly appreciated.

Thanks

 

[statsman]

When you initiate group or user level security, Access saves these settings in a file with the extentsion .mdw
If you are using the wizard, the default is System.mdw System.mdw resides in the C:Windows folder and is only valid for the one computer on which it resides.

The correct procedure is the create a new .mdw file with the security settings, place it in the same folder where your database resides (on the network) and include it in the path on the shortcut on each users desktop.

It sounds like you have created an .mdw file but have not instructed that it be run when opening the Access database.