Re: Access 97 Security issue Can't make a MDE
From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 12/21/04
- Next message: Suzie Raboin: "Re: Workgroup Problems"
- Previous message: Rick Brandt: "Re: Workgroup Problems"
- In reply to: Rick: "Access 97 Security issue Can't make a MDE"
- Next in thread: Rick: "RE: Access 97 Security issue Can't make a MDE"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Dec 2004 09:43:58 +1100
> Admin rights. I am not able to CHANGE these rights. Is there any way
This seems to be a basic problem. If you had sufficient permissions on
the database, you would be able to both make an mde, and change the
security settings on that table.
Normally I work as both the Owner of the database (and all objects
in it), and as a member of the Admins group used to create the database.
If you can't easily work out what happened to your security settings,
then you may want to start over again with a new database: then you
will know that you are the owner of everything, and that you have the
admins group used to create the database.
BTW, we don't reset this table permission after making the mde. Instead,
we give database admin permission to our user group. Database admin
permission is required by our user group so that users can change database
'properties', and user database admin permission ensures that the
correct user security settings propagate for these tables when you make
an mde. 'Admin' permission for the database object is NOT THE SAME
and does NOT MEAN THE SAME THING as 'Admin' permission for any other
kind of object in the database.
(david)
"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: Suzie Raboin: "Re: Workgroup Problems"
- Previous message: Rick Brandt: "Re: Workgroup Problems"
- In reply to: Rick: "Access 97 Security issue Can't make a MDE"
- Next in thread: Rick: "RE: Access 97 Security issue Can't make a MDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
