Hi John.
"John B" <menospam[ at ]menospam.com> wrote in message
news:13B80D37-657B-41DE-91D6-69AABE319C52[ at ]microsoft.com...
[Quoted Text] > Good-day Experts,
>
> 2 questions
>
> 1)
> I have a database that has security (user/password) defined by say person
> A
> on his machine. When person A opens the database, he gets user name and
> password prompt. However, when I opened it, I do not get the prompt (i.e.
> database is not secured). How can this be?
You have missed one or more steps in the securing process.
>
>
> 2) I have been reading the forum on Access database security and it seems
> like you need to create and join a workgroup. What happens if you are
> developing and testing the security settings on your PC but the taget
> environment is on a different workgroup/domain? Do I need to copy the
> database and set up password from that person's pc?
>
Essentially you leave the default workgroup alone and create a new custom
one for use by your app. You would store the workgroup information file in
a public folder so that all of your users can access it. Have you read the
MS FAQ on Access security? It is essential reading if you want to gain a
full understanding. There's a link to it on my web site. There's no filler
in the FAQ, it's all relevant and you need to understand it all.
Good luck.
Keith.
www.keithwilby.com
|