Keith,
Thanks for replying.
Doesn't look like it. Never played with Access security. Network-level
user security has always handled permissions so I never had to.
Here's where things are, now:
When I posted the first question, I had only 1 user (Admin) set up in the
test database. (Probably why it was ignoring the UID part of the
OpenDatabase command.) When I double-clicked the database to open it
manually, it asked only for the password. When I used VBA to open it, it
opened as long as the pwd was correct.
Since then, I used the wizard to set up a new user (BruceS) and assigned a
pwd (abcd). Now, when I double-click the database to open it manually, it
gives me a 3033 (no permissions) error. It doesn't prompt me for uid or pwd.
I can only open it by clicking on the .ldb file that the wizard created,
where it does ask for both uid & pwd.
Now, however, the VBA OpenDatabase command also fails with 3033, even when
using valid UID/pwd info in the parameter. Just for kicks, I tried pointing
it the .ldb file, instead. It errors saying that it's not a valid database
format.
Obviously, I don't know what I'm doing here. Can you point me in the right
direction?
Thanks,
Bruce
> > Hi, all!
> >
[quoted text clipped - 26 lines]
> Keith.
> www.keithwilby.com
Keith Wilby - 24 Apr 2007 14:45 GMT
> Keith,
>
[quoted text clipped - 28 lines]
> right
> direction?
Hi Bruce,
Well I misunderstood your first post. It seems you had no user-level
security set up (as I thought you had) but you *did* have a database
password set. Those two entities are completely separate and should not be
confused with each-other. I'm not sure what the answer is but I would
recommend that you don't dabble with user-level security if you're new to
it, you can very easily lock yourself out and it certainly won't solve your
original problem. I especially dislike the wizard because it does things
without telling you and you learn nothing about user-level security to help
you trouble-shoot when things go wrong.
Sorry I can't be of more help but hopefully someone else will jump in ...
Regards,
Keith.
BruceS - 24 Apr 2007 16:30 GMT
Thanks, anyway, Keith! Appreciate the effort.
Anyone else have a recommendation?
Bruce
> > Keith,
> >
[quoted text clipped - 45 lines]
> Regards,
> Keith.
BruceS - 24 Apr 2007 17:02 GMT
Keith,
Found what I needed at http://support.microsoft.com/kb/163002/en-us
Bruce
> > Keith,
> >
[quoted text clipped - 45 lines]
> Regards,
> Keith.
George Nicholson - 24 Apr 2007 23:25 GMT
The Bible (or at least one of them) on Access Security:
http://support.microsoft.com:80/kb/207793/en-us
HTH,
> Keith,
> Found what I needed at http://support.microsoft.com/kb/163002/en-us
[quoted text clipped - 60 lines]
>> Regards,
>> Keith.
BruceS - 25 Apr 2007 00:06 GMT
Thanks, George. If found that one, too, when searching the KB.
Bruce
> The Bible (or at least one of them) on Access Security:
> http://support.microsoft.com:80/kb/207793/en-us
[quoted text clipped - 65 lines]
> >> Regards,
> >> Keith.
Keith Wilby - 25 Apr 2007 09:38 GMT
> Keith,
> Found what I needed at http://support.microsoft.com/kb/163002/en-us
> Bruce
Nice, I may have a use for that myself, thanks for posting it.
Keith.