Access 97 Security issue Can't make a MDE

From: Rick (Rick_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 07:47:01 -0800

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: DAO Recordset does not have access rights
    ... this is why I'm not a fan of Access security. ... >> only works when the admin user has the required access rights. ... >> user has no rights to the database this line errors. ...
    (microsoft.public.access.modulesdaovba)
  • Re: DAO Recordset does not have access rights
    ... this is why I'm not a fan of Access security. ... > only works when the admin user has the required access rights. ... > user has no rights to the database this line errors. ...
    (microsoft.public.access.modulesdaovba)
  • Access 97 Security issue Cant make a MDE
    ... >I am trying to make a MDE of a database. ... Admin user rights to ...
    (microsoft.public.access.security)
  • DAO Snapshot does not have sufficient rights
    ... only works when the admin user has the required access rights. ... user has no rights to the database this line errors. ...
    (microsoft.public.access.security)
  • DAO Recordset does not have access rights
    ... only works when the admin user has the required access rights. ... user has no rights to the database this line errors. ...
    (microsoft.public.access.modulesdaovba)