Jim Dettman
jimdettman at verizon.net
Thu Jul 11 12:21:05 CDT 2013
John, Not sure if you saw my off-line e-mail or not yesterday, but it's sounds like your on your way. To de-secure a DB, you need the workgroup file it was secured with. Login as admin, open the DB, and then assign all rights to the users group for all objects (which is the same in every workgroup file). If your going to continue to use the same workgroup file with it, you can then set the admin user to a blank password. To strip out any remaining security, you'll need to start Access normally using the standard workgroup file, create a new db container, and then import all objects from the old DB. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Thursday, July 11, 2013 11:18 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Getting around old workgroup security No...tried that...doesn't work. But, what I did do is setup an old laptop that had Win 95 on it...yes, Win 95...and it also had A97. We just got this relic back from a department last week...good timing. I'm in the program, so now I just have to remove security...or so I am told. If any of y'all have any tips or instructions for this, I'm all ears...or in our case, I guess it is eyes ;o) I'm going to be googling now, but I'll look for your input. >>> "Rocky Smolin" <rockysmolin at bchacc.com> 7/10/2013 12:40 PM >>> Can you open a blank db in A2003 or later and import all the objects from the A97 db? Or save the A97 db in 2003 format or later and get around it that way? R Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. Thank you for your cooperation.