Hello All,
At work, all employees utilize Access 2000 on their individual computers. Our computers are all linked to a shared server in which there is a single Access database. My goal is create security for this database so that the employees can log into this database with limited permissions.
I know, basically, how to create the workgroup information file on my own computer and set up accounts/permissions, but how do I translate this so that it functions on a shared network? Does each employee need a new workgroup file installed on each of their computers or can I just put one file on the shared server along with the database? If that is the case, does this involve simply creating a shortcut on their computer to this new database with an added string in the target field that indicates which work-group information file to utilize? Could anyone briefly explain how I would do that? Are there any issues I might encounter in trying to translate what i know about security with my single computer database to a shared network database?
Thanks in advance for your help,
Dan