Re: Access 97 Security issue Can't make a MDE
From: Rick (Rick_at_discussions.microsoft.com)
Date: 12/21/04
- Next message: '69 Camaro: "Re: Problems with shared DB for multiuser"
- Previous message: Jeff: "unable to login"
- In reply to: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- Next in thread: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- Reply: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Dec 2004 08:57:02 -0800
I am the owner of the database, I was signed in with my own user ID which I
use for all other security administration for users of the DB. I have a user
ID I used to initially secure the DB (admin) is the username which ALSO has
admin rights. I am unable to make the MDE as either user. I will read the
info that you provided, thank you!
My problem is likely something else, I just assumed since the error
indicated I needed these other rights to this table that I should be able to
CHANGE them and simply proceed!
"'69 Camaro" wrote:
> Hi, Rick.
>
> > admin, the user that was
> > used to secure the database.
>
> If the default Admin user was the owner of the database when it was secured,
> then the database is not secure. For the steps needed to secure an Access
> database, please read the Security FAQ on the following Web page:
>
> http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
>
> > When I try to compile the mdb I get an error "The current user account
> does
> > not have permission to make an MDE file from this database".
>
> It's best to log in as the owner of the database before creating the MDE
> file, but a non-owner user with the following permissions can usually create
> the MDE file without trouble: Open/run database, open exclusive, modify
> design or administer for all tables, and read design permissions for all
> objects.
>
> > Several suggestions are listed, the one that applies seems to be "Make
> sure
> > that the user account has Modify Design or Administer permissions for the
> > MSysModules2 table in the database.
>
> The MSysModules2 table is a system table. No user has either of these
> permissions on any of the system tables. For more information, check the
> "Can't make an MDE!" checklist on the following Web page to help you
> determine if there are any other reasons why you can't create the MDE
> database:
>
> http://www.Access.QBuilt.com/html/conversion.html
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
>
>
> "Rick" <Rick@discussions.microsoft.com> wrote in message
> news:1EB114C1-9185-451B-894F-CDF04A59D224@microsoft.com...
> > I am trying to make a MDE of a database. I have both Admin user rights to
> > the dayabase as a user AND can sign in simply as admin, the user that was
> > used to secure the database.
> >
> > When I try to compile the mdb I get an error "The current user account
> does
> > not have permission to make an MDE file from this database". To make an
> MDE
> > file do the following:
> >
> > Several suggestions are listed, the one that applies seems to be "Make
> sure
> > that the user account has Modify Design or Administer permissions for the
> > MSysModules2 table in the database.
> >
> > This seems to be my problem, I do NOT have Modify Design or Administer
> > permissions for the table. Not signed in as the Admin user or as myself
> with
> > Admin rights. I am not able to CHANGE these rights. Is there any way I
> CAN
> > change these rights? Or have I somehow "Locked myself out of my own
> database"?
> >
> > Any help will be greatly appreciated!
>
>
>
- Next message: '69 Camaro: "Re: Problems with shared DB for multiuser"
- Previous message: Jeff: "unable to login"
- In reply to: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- Next in thread: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- Reply: '69 Camaro: "Re: Access 97 Security issue Can't make a MDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
