Well it matches my take on the situation....


>From: "Bellizzi Christopher J "
><mssqldba-ezmlmshield-x72129127.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Using Access to create reports and queries to a SQL server
>Date: Mon, 30 Jul 2007 16:02:03 -0400
>
>Lets see in my last job:
>
>I get a call from the guy and he say's "hey my query kept timing out so
>I set the timeout to 0 and now I get an error out of memory"
>I go look at the query and this is what I saw:
>
>Select * from my_2million_Row_table , my_7millionrow_table
>
>Hello McFly??
>
>So do you think the performance on the db was impacted?
>I guess if you only have a few people writing access db's then you can
>control it. If not, like in the last job you get 8700 + databases that
>take up space, don't have version control, point to one database or
>excel file which points to another database or gets changed sometime in
>the last month and when someone goes to report for month end gets
>errors.
>Hey Jeremy did I miss anything?
>
>PAYCHEX
>Christopher Bellizzi
>Information Technology * Database Administration
>675 Basket Road * Webster, New York 14580
>(585) 216-0670 * [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
>
>
>
>-----------------------------------------
>The information contained in this message may be privileged,
>confidential, and protected from disclosure. If the reader of this
>message is not the intended recipient, or any employee or agent
>responsible for delivering this message to the intended recipient,
>you are hereby notified that any dissemination, distribution, or
>copying of this communication is strictly prohibited. If you have
>received this communication in error, please notify us immediately
>by replying to the message and deleting it from your computer.
>
>Thank you. Paychex, Inc.
>
>
>---------------------------------------------------------------------
>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