I'm currently converting to an adp project and need help with the user login.
I want to use sql security rather than Windows NT security so that I can assign permissions to individuals rather than computers.
In the connection properties I have to put a user (my user number) and password in order for access to accept the connection properties but everytime you logon, my user number appears - doesn't matter who logged on previously. Is there anyway to change this so it remembers the previous logon as an mdb with mdw security does?
I want to use sql security rather than Windows NT security so that I can assign permissions to individuals rather than computers.
In the connection properties I have to put a user (my user number) and password in order for access to accept the connection properties but everytime you logon, my user number appears - doesn't matter who logged on previously. Is there anyway to change this so it remembers the previous logon as an mdb with mdw security does?