Workgroup File in MS Access 2003

Abbasi

New member
Local time
Today, 06:48
Joined
Jun 29, 2005
Messages
7
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.
 
You may have overlooked the fact that you must remove all rights from the default 'Admin' user.

???
:confused:
 
Yes, I have removed all the rights from the default "Admins" Group and assigned Administrative rights to a new "xyz" admin group. I also removed all the rights from the "Admin" user and assigned those rights to a new "xyz" adim user.

I have also transferred the "Owner" of all the files from the default "Admin" to the new "xyz" Admin.

But, it still does not function.

More help is highly appreciated.
 
When you do Tools->Security->User and Group Accounts, What is in the 'User Name' box?
 
Apparently, I have performed all the necessary operations - but in vain. I have completed 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.
 

Users who are viewing this thread

Back
Top Bottom