Permission Denied message

8 Mar 2009 4:05 AM

Kazlou

I recently set up security levels using the security wizard on a database.
This is the first time I've done anything with security levels. I set myself
as the administrator and gave different levels of access to the various
users. All seemed to work well.
When I went to go back into the database I got the following message

'You do not have the necessary permissions to use the "...database name
,..." Have your system administrator or the person who created the object
establish the appropirate permissions for you"

I thought that I'd be asked for a username and password to access the
database but this came up before anything else. What have I done wrong in
setting things up.

(I did make a full copy of the database before I started fiddling, so all is
still running smoothly, but I do have to get these security levels in place)

Thanks
Karen

8 Mar 2009 2:20 PM

Joan Wild

It's likely that the wizard created a desktop shortcut for your secure
mdb. Use that to launch it.

You're getting the message because you are joined by default to
system.mdw, a workgroup file that ships with Access. Since this mdw
file is common to every Access installation, you shouldn't be able to
open your secure mdb using it. However, you still want to have this
unsecured mdw as your default (for use with most mdb files that aren't
secure).

By using the shortcut, you bypass the default for just that session.
Look at the properties of the shortcut, and you'll see the /wrkgrp
switch on the target line.

Joan Wild
MS Access MVP

Kazlou wrote:
Show quoteHide quote

> I recently set up security levels using the security wizard on a database.
> This is the first time I've done anything with security levels. I set myself
> as the administrator and gave different levels of access to the various
> users. All seemed to work well.
> When I went to go back into the database I got the following message
>
> 'You do not have the necessary permissions to use the "...database name
> ,..." Have your system administrator or the person who created the object
> establish the appropirate permissions for you"
>
> I thought that I'd be asked for a username and password to access the
> database but this came up before anything else. What have I done wrong in
> setting things up.
>
> (I did make a full copy of the database before I started fiddling, so all is
> still running smoothly, but I do have to get these security levels in place)
>
> Thanks
> Karen
>