Heenan, Lambert
Lambert.Heenan at aig.com
Fri Jul 12 08:06:59 CDT 2013
See also http://office.microsoft.com/en-us/office-2000-resource-kit/removing-user-level-security-HA001138118.aspx?CTT=1 Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, July 12, 2013 9:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Getting around old workgroup security Quote from the horse's mouth: " 34. How can I "de-secure" a database? You need to have Administer permissions and/or be a member of the Admins group. Grant full permissions to the Users group and the Admin user account. Put the Admin user back in the Admins group and remove the password from the Admin user. You will not be prompted for a logon ID and password once the password is removed from the Admin user. Optionally, you can also run the Security Wizard again to transfer ownership of all objects back to the Admin user, but the wizard will also remove permissions from the Users group, which you may not want. " Lambert -----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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com