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

R

Rob

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?
 
J

Jerry Whittle

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.
 
M

Mikal via AccessMonster.com

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
 
Top