[AccessD] A97 User Security

Mark A Matte markamatte at hotmail.com
Mon Jan 10 10:07:53 CST 2005


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





More information about the AccessD mailing list