Microsoft Access mdw security file.
Posted on 2005-05-04
As you know Microsoft Access has a limitation of 255 users which can access a database at a time, the problem I have is that our company relies heavily on access and the mdw file that controls the security for access has reached it's limit (more then 255 people trying to open one of our Access DB at one time) therefore we have copied the mdw file and have created one for each major division of our company (Seven total) So far we have had no issues that we are aware of however our concern / question is as follows: Is the security controlled solely through the CID number that gets created (Like a autonum)when you create a new account? Or does Access take into consideration the users ID and Password they are required to enter when they open the database or does Access take into consideration only the CID number.
If I create a account for a new user for the IT Department lets say ID: i1990 (Full Rights) and Access assigns this account a CID number of 01 and then I create a account for a new user for the Finance Department lets say ID: i1991 (Read Only) and since the CID is a autonum and assigns this a CID number of 01 as well will Access distinguish the two and allow the appropriate rights?