Re: Access 97 Security issue Can't make a MDE

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 08:16:08 -0800

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!

Relevant Pages

  • RE: security wizard cannot be run
    ... I was fine with that until 'use your desktop shortcut'. ... for the Admin user. ... I tried to log on as Admin but couldn't get in to the database, ... Security permissions are stored in the mdb file. ...
    (microsoft.public.access.security)
  • Re: Security: User Account Problems
    ... > took your advice and removed Admin's permissions as you suggested. ... > prompted for a username and password to use the database. ... Did you secure it first, ... > refresh the links so that they point to the backend on the server. ...
    (microsoft.public.access.gettingstarted)
  • Re: is it possible to make a database secure after creating it as unsecure?
    ... can I make it secure completely then? ... assigned as the database owner, and all of the original owner's permissions ... Since the default Admin user still has permissions in the database, ... Security to secure your database, because anyone who really wants to break ...
    (microsoft.public.access.formscoding)
  • Re: Adding a database to existing workgroup file
    ... I did that (the Admin user was still in the User group, ... after changing and testing permissions, opened Access from my MS Office ... Access to the existing database is through a ... a database is not joined to a mdw file. ...
    (microsoft.public.access.security)
  • Re: FE and BE security
    ... The database splitter wizard creates a new database for the backend and ... To secure the backend now, ... permissions, and remove all permissions for the Users Group, and for the ...
    (microsoft.public.access.security)
Loading