I am looking for a way to have a table (or similar) in an access database that can be queried/read from but not seen in its entirity from any users.
For example, say I wanted a table that had 2 fields - UserName and Password.
There are 20 users in this table and each had a unique password to access another applicaton (or even a website).
A Windows user JBloggs is logged onto the network and runs the database where there is a button on a form called Get Password. When he clicks this, a piece of code is run to get his username from the windows logon session, passes it to the hidden table (or collection) and returns his password.
This is all hypothetical at the moment and was just wondering what methods ways I should use to explore this.
For example, is it possible to create a class library (dll) in Visual Studio with all the table values hard coded in and this dll then referenced from Access. By the Way I have to use Access so I may be limited in what I can achieve.
I look forward to any suggestions.