[AccessD] From a reader

Hello Susan --

What is given? - MS SQL backend with billions of rows? 
What is missing? - Relatively inexpensive way to implement web solutions to
present MS SQL backend data's small subsets/summary information?

if the answer on both of the above questions is 'Yes' then I suppose simple
ASP.NET applications + .NET MS ReportViewer control can be used.
One example: http://shamils-19.hosting.parking.ru/nw4 (ms access backend is
used here but using MS SQL backend doesn't differ a lot - in fact that
online MS Access backend-based solution is a port from original MS SQL-based
backend solution)

Some informational links on used for the above sample reporting technolgies:

http://www.gotreportviewer.com/
http://technet.microsoft.com/en-us/library/dd220460.aspx

And here MS WebMatrix - it wasn't used in the above sample but it can be
used by your reader I suppose:
http://www.asp.net/webmatrix
http://weblogs.asp.net/scottgu/archive/2010/07/06/introducing-webmatrix.aspx


Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 1 ??????? 2011 ?. 4:22
To: Access Developers discussion and problem solving
Subject: [AccessD] From a reader

I've been corresponding (lightly) with a reader who needs to upsize an
Access 2007 database to SQL Server -- ultimately, she's looking for a web
solution. It sounds like an excruciating application -- she said it takes
hours to run queries. I think she's looking for two things. First, she wants
something to analyze the Access database to make it more efficient. (I
haven't asked who built it to begin with, her or a professional developer.)
I told her to start with the utilities already there, the performance and
table analyzers. Are there any third-party products that do more or work
better? Second, she wants a plug-in GUI -- I've never heard of such a thing,
but I'll let you guys read her request and if you have something to suggest,
I'll relay it. Thanks!

Susan H. 
"What I am asking is: Is there a design solution that would make a large
sluggish access application scalable, faster, easier to distribute to remote
sites? All that I have read to date - is that SQL Server as the best and
most practiced solution. But, I still see that as "tons" of data still being
pushed between ACCESS and SQL Server - so how is that really better. Is
there a WEB or Sharepoint solution that would work as the ACCESS GUI
front-end and a backend SQL Server to crunch the billions of rows into the
summary levels of data?"
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com