Snafu 2

[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

 

[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


--

 

[Keith Wilby]

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

 

[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).