RE: 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 10:35:01 -0800

I figured that since I had not done anything explicitly that I know of to set
these permissions that I would likely end up importing the problem along with
everything else. Maybe I will give that a shot, I am going to go through the
check list recommended first though.

Rick

"Chris Reveille" wrote:

> 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: User Level Security Malfunction
    ... menu, the Users group has no rights to open the database, and it also ... I first create a blank secured file that I ... Remove Admin from Admins group ... Remove all permissions to "new" objects from Admin ...
    (microsoft.public.access.security)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Issue: LDB Not Being Created
    ... I would totally agree that it is a rights issue (and was convinced it ... I open the database and the LDB gets created. ... file create permissions, then all other users of the network would be able ... However if one user opens up the file does not have correct permissions to ...
    (comp.databases.ms-access)
  • Q: low permission cannot convert from A97 to A2000/2003
    ... A97, but the database is sent out and used by contractors (user permissions) ... The admin user has full privileges. ... The problem we are having is converting the database from A97 to 2000+. ...
    (microsoft.public.access.security)
  • Re: SQL Server 2005 Stored Procedure security annoyances
    ... stored proecedure on a database wide level? ... GRANT EXECUTE ON SCHEMA::MySchema TO MyRole ... I am sure I will forget some SP's and probably forget to set the rights ... permissions because not all stored procedures are equal. ...
    (microsoft.public.sqlserver.security)