I have inherited a system where MS Access is used as a report writer to MS
Sql.
There is a major performance hit.
A way around it is to create passthrough queries in MS Access.
A passthrough query essentially runs a stored proc on SQL.
The reports call the MS Access Passthrough query which calls a stroed proc
in SQL.
One of the issues is that MS Access requires all the data to do its own
selections etc..
HTH
John
-----Original Message-----
From: John A DAVIS
[mailto:mssqldba-ezmlmshield-x96327415.[Email address protected]
Sent: 31 July 2007 08:45 PM
To: LazyDBA Discussion
Subject: Re: Using Access to create reports and queries to a SQL server
Careful, you'll end up having to spend all day building stored procedures
and Crystal Reports for this person. Make sure she only has SELECT
permissions. Run profiler to see who is hoggin what resources. You might be
the culprit with all your Enterprise Managers and Query Analyzers. . . . . .
>>> "Norkett Margaret " <mssqldba-ezmlmshield-x99807782.[Email address
protected] 7/30/2007 11:25:31 AM >>> I have a developer here who LOVES to
use MS Access to create queries and reports in. She links tables from my
SQL2005 database in it and goes to town. I know I've read on this forum that
there is a performance hit involved with this practice (I think), so would
like to take information to my boss to help him discourage her from this
practice. What say ye? If you have any questions or concerns, please
let me know them. Margaret Norkett Database Administrator *
864-271-6522 ext 222 * 864-270-2884 Experience is the name
everyone gives to their mistakes. Oscar Wilde
<http://www.quotationspage.com/quotes/Oscar_Wilde/> , Lady Windermere's Fan,
1892, Act III Irish dramatist, novelist, & poet (1854 - 1900)
--------------------------------------------------------------------- TO
REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page