Using Access to create reports and queries to a SQL server

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)

~




MS Sql Server LazyDBA home page