Hi Margaret!
We have user-written apps that link to my SQL 2000 databases,
some with multiple simultaneous users. We also have users linking to
tables for 0ne-off queries thru Excel.
I haven't seen any performance hits with this practice and in the Excel
case it saves me from writing queries for the user - that's a good thing
for a Lazy DBA.
Emil

-----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