Online Query Tool SQL Server 2005

[csgraham74]

Hi,

I was wondering if someone could help advise me.

Basically i have a client who wants to upgrade from a desktop ms
access solution to a web based system using MS SQL Server 2005.

Basically their main concern is in losing the ability to write ad-hoc
queries using the MS Access query manager. I can obviously write
static reports etc but whats the best way to give them some
flexibility ??

Can anyone advise me if there is any product that can do this for SQL
Server 2005 (which im sure there is) but will work in a web
environment.

Or does anyone have any helpful ideas ???

all help / advice greatly appreciated

CG

[Erland Sommarskog]

Re: Online Query Tool SQL Server 2005

csgraham74 (csgraham74@gma il.com) writes:

Thanks for the response on this. Can they link to SQL SERVER 2005 that
would be hosted on a web server using MS Access?? my problem is that
the SQL server isnt on their local network ??

You mean that SQL Server is run by a hosting service? Just because you
run SQL Server on a web server does not preclude anything.

That would depend on the access provided by the hosting company. There
are no problems to access an SQL Server on a remote network, although
you probably have to use SQL authentication. But if the hosting company
does not expose SQL Server to your users, they lose of course.

I think you should discuss with the hosting service what options they
provide.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx