Snafu 2

9 Aug 2006 2:17 PM

Paul Hammond

This seemed worth a separate post.

I went through the wizard once more, this time using a tutorial from a text
book. I created one admin user, myself and one Full Permissions for a user.
This time I don't even get a login dialog.   I am told "You do not have the
necessary permissions..."

The good news is I can still use all my other databases.

This is why I have given up on using User level security on my databases. I
always crash and burn when I try it.   I've been using Access for near 10
years, but this stymies me.

Paul

9 Aug 2006 2:43 PM

Paul Hammond

Allright, I got it. Use the desktop shortcut, duh!

I guess I would need to distribute this shortcut to all my users too?

Paul

--

9 Aug 2006 5:49 PM

Joan Wild

Yes you would, however you need to verify that the path to msaccess.exe is
the same as on your computer. Look at the target of the shortcut in
properties (right-click it).

--
Joan Wild
Microsoft Access MVP

Paul Hammond wrote:

Show quoteHide quote

> Allright, I got it. Use the desktop shortcut, duh!
>
> I guess I would need to distribute this shortcut to all my users too?
>
> Paul
>
>
> --

9 Aug 2006 2:51 PM

Keith Wilby

Show quote Hide quote

"Paul Hammond" <phamm***@mediaREMOVEgeneral.com> wrote in message
news:DA739E27-3C51-471E-A8D1-970A85EE15D3@microsoft.com...
> This seemed worth a separate post.
>
> I went through the wizard once more, this time using a tutorial from a
> text
> book. I created one admin user, myself and one Full Permissions for a
> user.
> This time I don't even get a login dialog. I am told "You do not have
> the
> necessary permissions..."
>
> The good news is I can still use all my other databases.
>
> This is why I have given up on using User level security on my databases.
> I
> always crash and burn when I try it. I've been using Access for near 10
> years, but this stymies me.
>
> Paul
>

Don't be disheartened Paul ... have you read the FAQ from MS on security?
The problem with the wizard is that it does stuff without telling you or
explaining what's going on, so you don't get an understanding. My advice
would be to read through the FAQ and perhaps try my step-by-step example
(links to both on my web site). Be warned that the FAQ is "all killer, no
filler" and you must omit nothing.

Again, back up your files or work on a dummy to gain practice.

Regards,
Keith.
www.keithwilby.com