Security .mdw - how to add myself to list of users

[Jeff P via AccessMonster.com]

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.

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.

Thanks,
Jeff P.

 

[Scott McDaniel]

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

 

[Jeff P via AccessMonster.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

 

[Ed Metcalfe]

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

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.

 

[Jeff P via AccessMonster.com]

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.

Hi Scott,
I've been making my small changes to the beta version. I just need to

[quoted text clipped - 44 lines]
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.

 

[Scott McDaniel]

In that case, you'd need to have a valid username/password to login, and that login would need the appropriate
permissions to change the user list. YOu cannot directly edit the .mdw file in most cases; instead, you'd need to do as
Ed mentioned and login in with the correct workgroup.

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.

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.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com