[AccessD] A97 User Security

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