MartyConnelly
martyconnelly at shaw.ca
Thu Dec 23 11:00:57 CST 2004
Ooops I guess you need the URL http://accesstools.narod.ru/index.html Mark A Matte wrote: > Thanks Jim. > > Do you know if the www.lostpassword.com utility will work if I don't > have the original MDW? > > Thanks, > > Mark > >> From: "Jim Dettman" <jimdettman at earthlink.net> >> Reply-To: Access Developers discussion and problem >> solving<accessd at databaseadvisors.com> >> To: "Access Developers discussion and problem >> solving"<accessd at databaseadvisors.com> >> Subject: RE: [AccessD] A97 User Security >> Date: Wed, 22 Dec 2004 17:31:12 -0500 >> >> Mark, >> >> <<Thanks for the feedback...but there are no passwords on this db...>> >> >> Understood. There are various utilities out there, some work on the >> database password while others work on the workgroup file. You need the >> later. >> >> <<There are only 2 workgroups...Admins and Users...I belong to >> both...but >> don't have permission to change anything. I can't even view the >> permission >> settings of the groups. I'm guessing there was another workgroup...>> >> >> Yes. >> >> <<that has been removed?>> >> >> <<Is this possible?>> >> >> <<I've always used my own security...and >> never the built in...I'm not sure how they created it with no one >> having the >> authority to change anything?>> >> >> You would if you had the workgroup file that had the correct SIDs. >> In in >> the past, I've setup some DB's with exactly this setup. For >> development, I >> have one MDW. For the clients, they just use the standard MDW file. >> >> This is possible because the user 'Admin' and the group 'users' >> have the >> same SID (Security ID) no matter what MDW file you use. The group >> 'admins' >> however, is different for each one. >> >> So in your case, ownership of the objects belongs to someone that >> was in a >> different admins group, but the ability to run, view, etc was >> assigned to >> the users group (which is the same no matter which MDW you use). >> >> You need to break user level security and www.lostpassword.com does >> have a >> utility for that. >> >> Jim Dettman >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte >> Sent: Wednesday, December 22, 2004 11:49 AM >> To: accessd at databaseadvisors.com >> Subject: RE: [AccessD] A97 User Security >> >> >> Thanks for the feedback...but there are no passwords on this db...I >> have my >> own app that returns the database password...which the one mentioned >> below >> does...in addition to the user level stuff. The problem is there are no >> passwords(database or user level) in this db...and thats what this >> tool said >> also. But I still can't figure out how to modify permissions. >> >> Any ideas? >> >> Thanks, >> >> Mark >> >> >> >> >From: "Jim Dettman" <jimdettman at earthlink.net> >> >Reply-To: Access Developers discussion and problem >> >solving<accessd at databaseadvisors.com> >> >To: "Access Developers discussion and problem >> >solving"<accessd at databaseadvisors.com> >> >Subject: RE: [AccessD] A97 User Security >> >Date: Wed, 22 Dec 2004 07:19:12 -0500 >> > >> >Mark, >> > >> > Since it's user level security that's at play here, you'll need a >> >utility. >> >www.lostpassword.com is one site that offers such a utility. Do a >> Google >> >search on "access" "password" and you'll turn up a bunch. There are >> a few >> >Russian sites that have them for free. >> > >> >Jim Dettman >> > >> > >> >-----Original Message----- >> >From: accessd-bounces at databaseadvisors.com >> >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte >> >Sent: Tuesday, December 21, 2004 3:16 PM >> >To: accessd at databaseadvisors.com >> >Subject: [AccessD] A97 User Security >> > >> > >> >Hello All, >> > >> >I'm pretty sure this is a lost cause...but I just received an A97 >> >db...there >> >is no password...but I don't have permission to make any >> >changes(tables,queries...or even view the macros). My guess is I >> need to >> >know the UserGroup and PID that was used to change/create the >> permissions. >> >Is this correct...and are there any workarounds? >> > >> >Thanks, >> > >> >Mark >> > >> > >> >-- >> >AccessD mailing list >> >AccessD at databaseadvisors.com >> >http://databaseadvisors.com/mailman/listinfo/accessd >> >Website: http://www.databaseadvisors.com >> > >> > >> >-- >> >AccessD mailing list >> >AccessD at databaseadvisors.com >> >http://databaseadvisors.com/mailman/listinfo/accessd >> >Website: http://www.databaseadvisors.com >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > > -- Marty Connelly Victoria, B.C. Canada