Integrate Workgroup/Network Security?

[MikeC]

Can anyone tell me whether there is a way to Workgroup and
network security? If possible, I would like the Workgroup
security used by AXP to *automatically* authenticate any
users who have already successfully logged into the
network. The goal is to prevent the need to enter a
second user ID and password, but also benefit from the
native security features offered by Access.

 

[Rick Brandt]

Can anyone tell me whether there is a way to Workgroup and
network security? If possible, I would like the Workgroup
security used by AXP to *automatically* authenticate any
users who have already successfully logged into the
network. The goal is to prevent the need to enter a
second user ID and password, but also benefit from the
native security features offered by Access.

This is not possible.

 

[Andy]

I have the same problem as Mike. A way of getting round
this is to use Windows security to create a folder that
has access restricted to specific individuals/groups.
The .mdb file can then be kept in here and only authorised
individuals will be able to access it. This seems to work
if the database is split as well i.e. if the front end is
on a client machine and the back end is in the restricted
access folder on the network, then only authorised users
will be able to gain access to the data (a connection
error appears for unauthorised individuals). You will
probably want to experiment with this a bit - I'm not an
MVP and haven't really tested this approach properly!!!