Allowing user to look up values in DB through Page but Blocking DB Access

[Rebel7]

Hi Guys,

I have set up a page where a user or group of users enter a value in the page and then it looks up the values against the database and lets them know if the value exists or not.

The only problem is I do not want these users to be able to access the database and see all the values or make changes. I know that a password can be put on the database, but then they would be asked for the password when they try to use the page to look up the values against the database.

Basically, I want to keep it simple. They can only look up values through access to a simple page that allows them to enter the value they want to know about but cannot read, write or edit the database itself. Is this possible?


Thanks in advance.

 

[Pat Hartman]

Welcome aboard. You keep saying "page". Access doesn't use pages. Are you talking about a web page that is accessing a JET database? Don't confuse Access with Jet. They are two totally different animals.

If you are talking about a web page, you would need to create the code behind the page to check the user permissions and lookup the data. The page will do whatever you code it to do. There is nothing inherent in the Jet database to do what you are asking.