RE: Access 97 Security issue Can't make a MDE
From: Rick (Rick_at_discussions.microsoft.com)
Date: 12/22/04
- Next message: Greg Lonnman: "Does anyone have a form and VB code to allow users to change thei."
- Previous message: Rick: "RE: Pivot table permissions issue"
- In reply to: Rick: "Access 97 Security issue Can't make a MDE"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Dec 2004 06:01:03 -0800
Since everyone was so darn helpfull and provided such great info I thought I
would drop a note to share that the problem is solved and the solution came
from this discussion (Many thanks to all who contributed!).
I started going through the step by step checklist provided by Gunny at:
http://www.Access.QBuilt.com/html/conversion.html taking NOTHING for granted,
checking everything. Sure enough when I got to:
"If the database is secured using user-level security, are you currently
logged in as the owner of the database, or at least a member of the Admins
group? (For best results, make sure that you are logged into the workgroup
as the owner of the database. Being a member of the Admins group will
usually work, but not always.)"
Specifically checking although I KNEW I was the owner of the DB and all of
its components I double checked and SURE ENOUGH my boss apperently had to do
something in my absense one day and somehow ended up the owner of the
MSysModules2 table!!
When I logged in as him it was a snap to make the MDE as well as reclaim
MOST of the stuff I was no longer the owner of.
Great thing is I learned a couple other things in the process. I had been
looking for a good explanation of Acess security, now I have it as well as a
better understanding of some other issues.
Can't thank the group enough! Best wishs to all!!!
Rick
"Rick" wrote:
> 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: Greg Lonnman: "Does anyone have a form and VB code to allow users to change thei."
- Previous message: Rick: "RE: Pivot table permissions issue"
- In reply to: Rick: "Access 97 Security issue Can't make a MDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
