Re: can not open MDB file
From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 08/03/04
- Next message: Rick Brandt: "Re: Trouble in Security Land"
- Previous message: SecureMan: "Security"
- In reply to: Eric Butts [MSFT]: "RE: can not open MDB file"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 07:45:40 -0500
The list below can be shortened considerably.
Open db with a user name that has administrator credentials.
Grant full permissions on all objects to the default Users group
Close Access and reopen with a non-secure workgroup.
Create new file and import all objects from the original.
"Eric Butts [MSFT]" <ebutts@online.microsoft.com> wrote in message
news:eBmYF1OeEHA.1928@cpmsftngxa10.phx.gbl...
> Hi Rashid,
>
> To remove User-Level security (unsecure) on your Microsoft Access
database
> file perform steps similar to the following:
>
> 1. Join the workgroup information file (*.mdw) using Workgroup
Administrator
> (wrkgadm.exe) that defines security for the database that is secured.
>
> 2. Open the database you wish to unsecure using the logon that defines
Admin
> privileges for the database (not necessarily Admin).
>
> 3. Grant full permissions to the Users group and the Admin user account
for
> all
> objects in the database. Change the owner of all objects in the database
> to
> be the Admin user.
>
> 4. Quit Microsoft Access
>
> 5. Start Microsoft Access and open the secured database you wish to
unsecure
> using the Admin logon user name.
>
> 6. Create a new, blank database named UnsecureStep1.mdb.
>
> 7. Select Tools --> Security --> User and Group Permissions from the
menu.
>
> 8. On the Permissions tab, select Database from the Object Type
combo-box.
>
> 9. On the Permissions tab confirm that the Admin user and Users group
have
> full
> permissions (Administer) on the <Current Database> Object Name.
>
> 10. On the Permissions tab, select Table from the Object Type combo-box.
>
> 11. On the Permissions tab confirm that the Admin user and Users group
have
> full permissions on the <New Object> Object Name.
>
> 12. Repeat Steps 10 and 11 for each Object Type: Query, Form, Report,
Macro
>
> 13. Select the Change Owner tab.
>
> 14. Select Database from the Object Type combo-box and confirm that Admin
is
> the Current Owner of the database and click OK. If not, close the
database
> and start fresh at Step 1.
>
> 15. Select File --> Get External Data --> Import from the menu.
>
> 16. Browse to the secured database and import all of the objects into the
> blank
> database.
>
> At this point, you will have a database that is currently in an unsecured
> state
> (UnsecureStep1.mdb) but still associated with the workgroup information
> file
> that defines security for all databases.
>
> 17. Quit Microsoft Access
>
> 18. Join or create a default workgroup information file using Workgroup
> Administrator (wrkgadm.exe).
>
> 19. Start Microsoft Access.
>
> 20. Create a new, blank database named UnsecureStep2.mdb.
>
> 21. Select File --> Get External Data --> Import from the menu.
>
> 22. Browse to the UnsecureStep1.mdb database and import all of the
objects
> into
> the blank database.
>
> I hope this helps! If you have additional questions on this topic,
please
> respond back to this posting.
>
>
> Regards,
>
> Eric Butts
> Microsoft Access Support
> ebutts@online.microsoft.com
> "Microsoft Security Announcement: Have you installed the patch for
> Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
> you to review the information at the following link regarding Microsoft
> Security Bulletin MS03-026
> <http://www.microsoft.com/security/security_bulletins/ms03-026.asp>
and/or
> to visit Windows Update at <http://windowsupdate.microsoft.com/> to
install
> the patch. Running the SCAN program from the Windows Update site will
help
> to insure you are current with all security patches, not just MS03-026."
>
> This posting is provided "AS IS" with no warranties, and confers no
rights
>
>
> --------------------
> | Content-Class: urn:content-classes:message
> | From: "Rashid" <rashidamber@hotmail.com>
> | Sender: "Rashid" <rashidamber@hotmail.com>
> | Subject: can not open MDB file
> | Date: Fri, 30 Jul 2004 20:34:24 -0700
> | Lines: 8
> | Message-ID: <7b2901c476af$46321c20$a501280a@phx.gbl>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="iso-8859-1"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Thread-Index: AcR2r0Yyk2UzI85GQNqyFT75TcAxBA==
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> | Newsgroups: microsoft.public.access.security
> | Path: cpmsftngxa10.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:12491
> | NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
> | X-Tomcat-NG: microsoft.public.access.security
> |
> | I copied a MDB from one computer to other computer, but
> | can not open that file because of the permission issue...
> | I am really tired of this situation... I want to remove
> | completely the security options.. want to remove any kind
> | of permission issue... How can I do that... The Safe
> | Source Code is also running on main computer, I would
> | like to remove that also... Please help me...
> |
> |
>
- Next message: Rick Brandt: "Re: Trouble in Security Land"
- Previous message: SecureMan: "Security"
- In reply to: Eric Butts [MSFT]: "RE: can not open MDB file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
