I found these as well to try:
MS Access optimization articles:
http://support.microsoft.com/?kbid=286222 -How to optimize Microsoft Access
when using ODBC data sources
http://support.microsoft.com/default...;EN-US;q209126 -Excellent
Information about query performance in an Access database.
"Dan V." <danv@yah.com> wrote in message
news:epBElK8gFHA.3692@TK2MSFTNGP09.phx.gbl...[color=blue]
> I found this article:
>
http://www.nethost.co.il/heb_v/iis5_performance.htm
>
> And will try it. Trying to find out if it makes a difference if you index
> the select and / or where fields in the query.
>
> I didn't test this myself, but if the complex query is run in MS access on
> that machine not using ASP.NET at all, it is the same speed I was told.
>
> "Richard L Rosenheim" <richard@rlr.com> wrote in message
> news:uFSJvr2gFHA.1248@TK2MSFTNGP12.phx.gbl...[color=green]
> > That's interesting. My brother has encountered a very similar problem[/color]
> with[color=green]
> > his web application.
> >
> > Access database (simple queries, and very little data in the tables),[/color]
> plain[color=green]
> > ASP code (not ASP.NET), Windows 2003 Server (w/IIS 6). It's taking a[/color][/color]
long[color=blue][color=green]
> > time for the ASP page to render, even locally. I was thinking maybe the
> > issue was with the ASP engine, but maybe the problem is with Access.
> >
> > Unfortunately, I don't have any other useful information to provide, nor
> > have we been able to track down or resolve the issue.
> >
> > If I get time, I think I might try converting a page to use a SQL Server
> > database. See what results I get...
> >
> > Richard Rosenheim
> >
> >
> > "Dan V." <danv@yah.com> wrote in message
> > news:Oyvno1xgFHA.2916@TK2MSFTNGP14.phx.gbl...[color=darkred]
> > > We use dot net, asp.net and iis 5 on a pentium 1.2 GHZ (dual capable -[/color][/color]
> one[color=green][color=darkred]
> > > in now) and 1 MB RAM and Access 2002.
> > > Our ASP.NET Database queries to MS Access (running locally) are very[/color][/color]
> slow,[color=green][color=darkred]
> > > (the programmer can't change this)
> > > and they take between 2 - 15 seconds to load a data page -this is even[/color][/color][/color]
[color=blue][color=green][color=darkred]
> > > running locally on the web server. There are multiple web sites on[/color][/color][/color]
this[color=blue][color=green][color=darkred]
> > > server, with not too much traffic.
> > >
> > > Our goal is to have 100-200 simultaneous users of this Access[/color][/color][/color]
database.[color=blue]
> We[color=green][color=darkred]
> > > can't change the database right now or the code.
> > > What should we do? Upgrade or buy new?
> > >
> > > thanks
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
