Hi there,
I have a db on my computer, and I have set up 3 user accounts. Admin, Power and User.
I have created these accounts myself and selected what they can and can't do.
However, now, when I try to open another db on this pc, or even if I create a new one, it asks for these credentials? So I don't seem to be able to put nothing (it prompts for username/password everytime) and putting in the password for the accounts on my first database doesn't work either (as they are not set up for this new one).
When I move the db to a new computer, it allows me in to the db without requiring a password or username.
Can anyone help tie the security creds to this db only and not to the pc?
Thanks!