[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