"Permission Denied" trying to run any Access 2002 wizard. Help!

J

Jackie Kennerley

OK Folks, this is (to me) a weird one, but it seems fairly obvious to me
that I don't fully understand the security settings. Here's the deal:

MS Access 2002, running on Win XP Pro, and being used from a (Windows)
Power Users account.

I created all my tables manually, and then went to use the query wizard,
and I got an error dialog that said simply, "Permission Denied".

I fiddled for a bit, and discovered the following:

a) The "Permission Denied" error occurs when I try to run *any* wizard.
Table, Query, Form, you name it.

b) The error is not confined to this db. A new db produces the same
results.

c) The error occurs *irrespective* of any (Access) security settings
(ie. table owners, permissions (ie. User or Owner), etc., etc.)

d) The error DOES NOT OCCUR when I run Access from the (Windows)
Administrator account.

Any clues, security gurus?
--

Cheers,
Dave

-----------------------------------------------------------
"...another day in this suburban nightmare
and I would've needed half a white Valium."

C. Montgomery Burns
-----------------------------------------------------------
"God speed, little doodle."

Ned Flanders
-----------------------------------------------------------
"Whenever I held [my gun], I felt this incredible surge of power;
Like God must feel when *He's* holding a gun."

Homer Simpson
-----------------------------------------------------------
 
G

GVaught

Make sure your power user account has read, write, execute privileges on the
folder where the database resides. Write privileges are needed in order for
users to write to the ldb file that is generated when they open the
database. They also may need certain privileges on any parent folders.

If you have internal User security make sure your users have the appropriate
permissions to create new queries, forms, reports etc. Permissions need to
be set on each existing queries, forms, etc as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top