Hey Margaret,
Our policy is to inform the sections that use Microsoft Access that we
will help them when we can and if we can but they are not "priority".
It is also their responsibility to get the required training and that
using and troubleshooting Microsoft Access is their primary duty and
responsibility. Also, they were made aware of performance issues
resulting from poorly created queries and reports.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Norkett Margaret
[mailto:mssqldba-ezmlmshield-x99807782.[Email address protected]
Sent: Monday, July 30, 2007 2:26 PM
To: LazyDBA Discussion
Subject: Using Access to create reports and queries to a SQL server
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
MS Sql Server LazyDBA home page