Mark A Matte
markamatte at hotmail.com
Tue Jan 11 08:46:54 CST 2005
Drew, This is my machine at work...so I have little control over what's on it...but with a little research...I now know I have 3.51.2723.0 Service Pack 2 (SP2) installed on this machine. Thanks, Mark >From: DWUTKA at marlow.com >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] A97 User Security >Date: Mon, 10 Jan 2005 12:44:36 -0600 > >Okay, curious if 1a or 1b still let ya do that trick. > >Just out of curiousity, you are developing with the latest SP, right? ><grin> > >Drew > >-----Original Message----- >From: Mark A Matte [mailto:markamatte at hotmail.com] >Sent: Monday, January 10, 2005 11:06 AM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] A97 User Security > > >Drew, > >I'm assuming I goto Help...About Microsoft Access...and this would tell me >what service pack is installed? ...and if this is the case...then I believe >I'm at the 'no service pack' level. > >Mark > > >From: DWUTKA at marlow.com > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: accessd at databaseadvisors.com > >Subject: RE: [AccessD] A97 User Security > >Date: Mon, 10 Jan 2005 10:24:36 -0600 > > > >Glad to help. Just out of curiousity, what Service Pack did you have > >installed to get the drag and drop trick to work? I know it doesn't work > >in > >2b (which was the last one), but I have never bothered to try and figure > >out > >how far back you have to go, I just know the 'no service pack' level does > >it. > > > >Drew > > > >-----Original Message----- > >From: Mark A Matte [mailto:markamatte at hotmail.com] > >Sent: Monday, January 10, 2005 10:08 AM > >To: accessd at databaseadvisors.com > >Subject: RE: [AccessD] A97 User Security > > > > > >Drew, > > > >I didn't think it was an MDE because I could see the code behind the > >forms...just couldn't change anything...but the drag and drop trick >worked. > > > >This is definitely one to remember. > > > >Thanks, > > > >Mark > > > > > > >From: DWUTKA at marlow.com > > >Reply-To: Access Developers discussion and problem > > >solving<accessd at databaseadvisors.com> > > >To: accessd at databaseadvisors.com > > >Subject: RE: [AccessD] A97 User Security > > >Date: Mon, 3 Jan 2005 14:32:01 -0600 > > > > > >Sorry for the delayed response, but from the looks of this thread, you > >are > > >either dealing with an .mde renamed as an .mdb. Possible. Or you have >a > > >secured .mdb, and you don't have the proper .mdw to get into it. > > > > > >There are password utilities out there, but they require the .mdw. > > > > > >There is another option. This is an Access 97 .mdb. There is a little > > >known glitch in Access 97 (without the service packs, because one of >the > > >service packs fixed the glitch!), which allows you to drag and drop > > >database > > >objects from one database to another, REGARDLESS of security. So you >may > > >not have access to even open a form, but as long as you can see the > > >database > > >window, you can drag the form to a blank (unsecured) database, and > > >everything is copied (code and all). This is due to the 'bug', which >in > > >the > > >drag and drop 'process', the original (unpatched) code just doesn't > >bother > > >to check for security settings before it copies the objects to another > > >database. > > > > > >Hope this helps. > > > > > >Drew > > > > > >-----Original Message----- > > >From: Mark A Matte [mailto:markamatte at hotmail.com] > > >Sent: Tuesday, December 21, 2004 2: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 > > >-- >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