Currently, we have a SITES. mdb file and its associated ldb file residing on a file server. All of the users (50) connect internally to this mdb file over the network. Each workstation has Access installed on it. I am at the point where I need security on this mdb file but have the following questions:
Since the Jet engine is on each individual workstation, how do I setup central security? If I setup a copy of Access on the file server, does that handle the security for all workstations? What about other users of that file server that have Access applications that have nothing to do with SITES? Will they then be asked to log on to their applications? What happens if security is setup on the SITES.mdb file and a user creates a new database at their workstation? Would they then have to log in to their new database or would their be no security yet on the new mdb file? One of my resources is the Access 95 Developer's Handbook by Litwin and Getz, but it doesn't answer these overview type questions.