Security-Database on Network

[Guest]

We have a database that is stored on the network. I use the Current User in
some of my queries. How do I prompt people for their user name when they open
this database? We have other databases on the network but we don't want them
to have to sign in for those databases. When you use the security wizard,
does this set up security just for a specific database or just for the hard
drive?

Thanks.

 

[Keith]

We have a database that is stored on the network. I use the Current
User in some of my queries. How do I prompt people for their user name
when they open this database? We have other databases on the network
but we don't want them to have to sign in for those databases. When you
use the security wizard, does this set up security just for a specific
database or just for the hard drive?

I've never used the wizard but what you need to do is create your own
"Workgroup Information File" (.mdw - place it in a public place on the
server) and leave the default "system.mdw" alone. Presumably the wizard
will prompt you for this kind of info.

As always, work on a COPY of your files.

Regards,
Keith.
www.keithwilby.com

 

[Joan Wild]

We have a database that is stored on the network. I use the Current
User in some of my queries. How do I prompt people for their user
name when they open this database? We have other databases on the
network but we don't want them to have to sign in for those
databases. When you use the security wizard, does this set up
security just for a specific database or just for the hard drive?

Using CurrentUser in your queries isn't worth much if you don't implement
security - without security it will return Admin for everyone.

There is more to security than running the wizard, but to answer your
question you can set it up for just one database.

Perhaps, for your purpose, you'll find using the network login name as a
criteria more suitable. See
http://www.mvps.org/access/api/api0008.htm
for a function to do this.

 

[Guest]

Thank you - that's exactly what I needed.

Using CurrentUser in your queries isn't worth much if you don't implement
security - without security it will return Admin for everyone.

There is more to security than running the wizard, but to answer your
question you can set it up for just one database.

Perhaps, for your purpose, you'll find using the network login name as a
criteria more suitable. See
http://www.mvps.org/access/api/api0008.htm
for a function to do this.