Workgroup File in MS Access 2003

[raabbasi]

I created a Workgroup file (Project.mdw), assigned different Permissions to different Groups, and put different Users in appropriate Groups.
The above setup is working fine and just as required. But, if I remove or rename the Workgroup file, MS Access does not look for it, creates in its own Workgroup file and starts just as usual - without asking for the Password, or caring about the Permissions and/or restrictions set.
How can I make the database file bound to the MDW file, so that it does not open without it.

 

[lupins46]

You cannot tie one to the other in any absolute sense.
But I'm afraid that what you have related means that you have not implemented security correctly otherwise opening the database with a default mdw file would prohibit database usage.

You can get lots of detail of how to set up seceurity of the net but the most comprehensive source, albeit not the simplest, is found here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

A more straightforward guide is here:

http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

 

[raabbasi]

Unfortunately, I am still in trouble with this problem.
I have tried to understand and practiced according to the information stated in the links forwarded by Lupins46.

Apparently, I have performed all the necessary operations completing the following steps:

(1)- Created an MDW file.
(2)- Created User & Group Accounts.
(3)- Added New User (only One) to the 'Admin 'group.
(4)- Removed 'Admin' from the 'Admins' group.
(5)- Set Password for the default 'Admin' user.
---------------------------------------------------
(6)- Re-started MS Access with the 'NewAdmin' user .
(7)- Set the Password for the 'NewAdmin'.
(8)- Created 'Full Permission' & 'Read-Only Groups'
(9)- Set 'Users-group' have No permissions.
(10)- Added New Users
(11)- Put "User1" into 'Full Permissions' group.
(12)- Put "User2" into 'Read-Only' group.

It will be great help, if someone can point out, where I have gone wrong, please.