network user only needs to run one query from a database.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, we are using Access 2003. We have a query defined that will prompt a
user for a starting date and ending date, then extract the necessary
information and display it to the user. The problem is we do not want this
particular user to have access to all the queries. Is there a way to create a
form that she can access the query from, then have that on her system so she
never actually goes to the server to open the database?
 
Sure. Go to Pages on the Objects bar. Create a Data Access Page that does
what you want. Save that page on the network and the user can open it using a
web browser like Internet Explorer.
 
Rob said:
Hi all, we are using Access 2003. We have a query defined that will prompt a
user for a starting date and ending date, then extract the necessary
information and display it to the user. The problem is we do not want this
particular user to have access to all the queries. Is there a way to create a
form that she can access the query from, then have that on her system so she
never actually goes to the server to open the database?
Click to expand...

If you don't want to go the DataAccessPage route as Jerry Whittle suggested,
(or maybe you can't for some reason) you can give this user his own front-end
with nothing available to him but the one query and a report based on it.
The relevant tables will all have to be connected, but they can be concealed
and if the user is not particularly sophisticated, that might be enough.
This approach has the additional advantage of allowing you to easily add
functionality for this person if you decide it is the right thing to do.

On the other hand, if the guy is just a flake and can't be trusted at all,
forget what I just said.

HTH
Mike

--
Mike Pippins

"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.com
 
Back
Top