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

csgraham74 (csgraham74 (AT) gmail (DOT) com) writes:
If they are used to Access, they can still use it as a query tool against
SQL Server, either through linked tables or something called ADP. You may
get more information about this in an Access newsgroup.

SQL Server ships with SQL Server Management Studio where you can run
ad hoc-queries all day. It even includes a query designer, but it's
outright crap you should stay away from. Mgmt Studio is not very useful
if you want nice formatting of the output.

You can also use Reporting Services, a component that comes with SQL Server.
I have not used it myself, but I believe that it could fit the bill.

Then there are of course lots of third-party tools out there. A recent
issue of SQL Server Magazine reviewed a couple of report tools. I don't
remember exactly which, November or Decmber 2007, I think.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On 17 Feb, 23:11, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
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 ??

if this is possible then great

thanks

C

csgraham74 (csgraham74 (AT) gmail (DOT) com) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx