Access 97 Security issue Can't make a MDE

From: Chris Reveille (anonymous_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 09:42:24 -0800

Why not create a new MDB and import all the
tables,queries,forms,macros,reports, and modules.

Chris Reveille

>-----Original Message-----
>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: Access 97 Security issue Cant make a MDE
    ... I am not able to CHANGE these rights. ... Normally I work as both the Owner of the database (and all objects ... we don't reset this table permission after making the mde. ... we give database admin permission to our user group. ...
    (microsoft.public.access.security)
  • Re: MDE not possible ?
    ... First compile the MDB and make sure that there are no errors in the code ... before creating the MDE. ... Because of the methode used to compile the database a lot of references ... If your database is in Access 2000 file format (it should say on ...
    (microsoft.public.access.formscoding)
  • Re: Acces VBA Password
    ... > the product, the Make MDE file selection is not enabled on the Tools, ... Web page to help you determine why you can't create the MDE database: ... version of the VBA source code, even if there's a VBA password placed on the ...
    (microsoft.public.access.security)
  • Re: MDE not possible ?
    ... I converted my frontend MDB to the Access 2002-2003 format and tried to ... I get an error that the MDE couldn't be created. ... This error occurse mostly while compiling big databases to a MDE file. ... Because of the methode used to compile the database a lot of references will ...
    (microsoft.public.access.formscoding)
  • Re: Log In
    ... Microsoft Access MVP ... Microsoft Office Access was unable to create an MDE database. ... opens the form? ...
    (microsoft.public.access.security)