Our company has two databases.
The main and an access database. The access db uses information in the main db using an sql repli. That is the main db isn’t sql, but every time there is an update it will replicate itself as various sql tables (views) on the sql server. I then link these tables in access.
I need to place a password on a few sections of the access db, but I want to be able to use the passwords from the main db rather than have the users remember anymore passwords at work.
The passwords could be put into a sql table on sql server.
However I don’t want to be in a position to be able to know what those passwords are.
Is there a way of making these passwords on sql server, unreadable to all users and also to the admin of the access db.
