469,963 Members | 2,056 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

Online Query Tool SQL Server 2005


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

Or does anyone have any helpful ideas ???

all help / advice greatly appreciated

Feb 17 '08 #1
1 2149
csgraham74 (cs********@gmail.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
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Feb 18 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Daven Thrice | last post: by
1 post views Thread by TF | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.