We are running a system with front end and back end MS Access 97 databases, under the control of VB6 programs, running with DAO/Jet. What is the best way to set the security flags?

What effect does the fact that we are applying security to linked tables have, if any?

Does the resulting security value behave in a similar way to group/user security ie. least restrictive?

I would be grateful to hear from anyone who has had similar problems.