Run query without sql server (2000)

Hi all,
I wrote a query in SQL server query analyser and would like a user to run this regularly. However itâ's not possible to give them SQL server. Can they do this another way i.e. through Access or similar?
Many thanks
IGYou could just install sql server client utilities (without the server).
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
Hi all,
I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IG|||You must install the SQL client connectivity piece for them to use SQL OR
Create some middle tier object with access and let them use the middle tier
object
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
> Hi all,
> I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
> Many thanks
> IG
>|||You can install ODBC on the client, create a data source pointing back to your SQL database, create your query as a view on your SQL box, then use Access to link the view as a table/data source. I do it all the time for user reporting. It provides data integrity because you can make the view read-only so users can't change the data, and the users can only see what you let them, so you have data security.
It's also a good way to make ad hoc query tools when you want to provide the intelligence so that the users don't have to learn SQL.