>>I'm new to my department and starting to make changes to the production
>>database.  The owner of this database is no longer here.  The database is
>>secured by the security workgroup, "secured.mdw".  It won't allow me to
>>export my new queries and form changes because of permissions.  I'm not on
>>the userlist. 
>
>If you're "not on the userlist", how are you logging in and making changes? If you can log into the database, then the
>username/password that you're using to do so is in the secured.mdw file.
>
>>Is there a way that I can bypass this function and add myself to the list.  I
>>need to add these changes for today for AP.
>
>That would depend on the permissions given to each Group/User. If the original developer provided your user, or a Group
>your user belongs to, with the necessary permissions to do this then you can. Otherwise then no, you wouldn't be able to
>do so. Are there no Admin users for the database? If not, can you contact the original developer and get the Admin
>user/pass from them?
>
>Scott McDaniel
>scott@takemeout_infotrakker.com
>www.infotrakker.com

> Hi Scott,
> I've been making my small changes to the beta version.  I just need to
> export
> the new queries and form changes. When I click on the .mdb database, The
> error states: " You do not have the necessary permissions.  Have the
> administrator that created this object establish the appropriate
> permissions
> for you"
>
> I can open the secured.mdw database and see the list of users, but I can't
> add myself.  I see MSysGroupList, MSysGroupMembers, SSysUserList and
> MSysUserMemeberships.  When i go into design view, it tells me that only
> read-
> only is possible.
>
> Would these permissions allow me to get around the security and add
> myself?
> and How?
>
> Thanks,
> Jeff
>
>
>
> Scott McDaniel wrote:
>>>I'm new to my department and starting to make changes to the production
>>>database.  The owner of this database is no longer here.  The database is
>>>secured by the security workgroup, "secured.mdw".  It won't allow me to
>>>export my new queries and form changes because of permissions.  I'm not
>>>on
>>>the userlist.
>>
>>If you're "not on the userlist", how are you logging in and making
>>changes? If you can log into the database, then the
>>username/password that you're using to do so is in the secured.mdw file.
>>
>>>Is there a way that I can bypass this function and add myself to the
>>>list.  I
>>>need to add these changes for today for AP.
>>
>>That would depend on the permissions given to each Group/User. If the
>>original developer provided your user, or a Group
>>your user belongs to, with the necessary permissions to do this then you
>>can. Otherwise then no, you wouldn't be able to
>>do so. Are there no Admin users for the database? If not, can you contact
>>the original developer and get the Admin
>>user/pass from them?
>>
>>Scott McDaniel
>>scott@takemeout_infotrakker.com
>>www.infotrakker.com
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200705/1
>

>> Hi Scott,
>> I've been making my small changes to the beta version.  I just need to
>[quoted text clipped - 44 lines]
>>>scott@takemeout_infotrakker.com
>>>www.infotrakker.com
>
>Jeff,
>
>You don't need to open the MDW file in MS Access. Connect to it via
>Workgroup Administrator (how you access this depends on which version of
>Access you are using). Then open up your MDB file. Now go to Tools >
>Security > User and Group Permissions.
>
>This *may* allow you to assign the necessary rights to your user. If not you
>will need to get the necessary admin user to grant you the rights.
>
>If nobody has the rights to do this, and you have the necessary authority to
>do so, there are programs available that can retrieve all user
>names/passwords from an MDW file so you can find the developer's login
>credentials. Doing this without the proper authority is, of course, illegal
>in most countries.
>
>Ed Metcalfe.

>I have Access 2000.  But, I can't get pass the login screen even when I hold
>down the shift key.  So I can't see the tools menu to access the workgroup
>permissions.
>
>Ed Metcalfe wrote:
>>> Hi Scott,
>>> I've been making my small changes to the beta version.  I just need to
>>[quoted text clipped - 44 lines]
>>>>scott@takemeout_infotrakker.com
>>>>www.infotrakker.com
>>
>>Jeff,
>>
>>You don't need to open the MDW file in MS Access. Connect to it via
>>Workgroup Administrator (how you access this depends on which version of
>>Access you are using). Then open up your MDB file. Now go to Tools >
>>Security > User and Group Permissions.
>>
>>This *may* allow you to assign the necessary rights to your user. If not you
>>will need to get the necessary admin user to grant you the rights.
>>
>>If nobody has the rights to do this, and you have the necessary authority to
>>do so, there are programs available that can retrieve all user
>>names/passwords from an MDW file so you can find the developer's login
>>credentials. Doing this without the proper authority is, of course, illegal
>>in most countries.
>>
>>Ed Metcalfe.