Re: Report is slow for non administrator Access 2007
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
If you haven't installed the latest Office 2007 service pack, you could try
that. The original RTM version had some performance problems that were
improved with service packs, and maybe you're lucky and yours falls into
that category.
"Arog" <Arog@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04F6DD6E-C956-4528-9730-D40C9DEE6C53@xxxxxxxxxxxxxxxx
I am converting an application from Access 2003 to Access 2007. The report
is against a view containing several million records in SQL Server 2008.
In
the Report_Open event I load the serverfilter property to filter the
report..
When the report runs on 2003 or as Server Administrator in 2007, it comes
up
very quickly. In 2007 as a regular user it seems to hang for quite a while
before the actual report comes up.
In SQL server profiler in 2003 and as admin in 2007 the filtered query
gets
sent immediately. As a regular user a simple "select * from myview" with
no
where clause gets sent and the app presumably waits for all records to be
returned. Later the correct query gets sent and the report comes up.
I tried putting 1=2 into serverfilter at design time, to no avail.
I have worked around this problem by putting "select * from myview where
1=2" instead of the view name into the recordsource property.
We need to convert to 2007 to take advantage of the ability to generate
PDF
files.
This is the tip of the iceberg as we have a lot of reports that are
dynamically filtered on views.
It sounds like some sort of permissions problem. Is there some privilege
that can be assigned the users on sql server that will fix this?
.
Relevant Pages
- Report is slow for non administrator Access 2007
... the Report_Open event I load the serverfilter property to filter the report.. ... In 2007 as a regular user it seems to hang for quite a while ... In SQL server profiler in 2003 and as admin in 2007 the filtered query gets ...
(microsoft.public.access.adp.sqlserver) - Re: MS Access Reports and VB.NET Program
... think that I want to ship a 30mb .NET framework to each of my clients? ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
(microsoft.public.dotnet.languages.vb) - Re: MS Access Reports and VB.NET Program
... It's not always about you Aaron. ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
(microsoft.public.dotnet.languages.vb) - Re: Converting app to ASP?
... If they used a report writer the reports would take a few seconds to process but they pass the report on to the clients and not all of their clients may have Access but would have Excel. ... On the other hand if those developers are really talented developers then they might be able to offset some of those increased costs. ... We see weekly posts in the SQL server newsgroups that when people move their data from an access backend to that of SQL server, ... often the greatest value in any application built is all the business requirements and gathering and building something that the employees need. ...
(comp.databases.ms-access) - Re: Converting app to ASP?
... If they used a report writer the reports would take a few seconds to process but they pass the report on to the clients and not all of their clients may have Access but would have Excel. ... developers are really talented developers then they might be able to offset some of those increased costs. ... I noticed in the past that a key user of the application has less than 500K memory so perhaps delay is from the memory, ... We see weekly posts in the SQL server newsgroups that when people move their data from an access backend to that of SQL server, ...
(comp.databases.ms-access) |
|
