The average "witch" or male counterpart would be using ODBC but you can just use VBA and connect using an OLEDB string with no linked tables.

You can also use a passthrough query that bypasses the whole Jet engine. Just save a password query and then in code change it's .SQL property.



>>> "Jeremy Greaves " <mssqldba-ezmlmshield-x19141536.[Email address protected] 7/30/2007 1:00:58 PM >>>


Actually....
The method of connectivity between MS-Access to any external database is via
ODBC. Each activity or interaction of MS-Access with the DB needs to be
brokered via ODBC, and this causes a performance degradation. MS-Access
doesn't interact directly with the server.


Jeremy Greaves
Fenris Software Consulting, Inc


>From: "Norkett Margaret "
><mssqldba-ezmlmshield-x99807782.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: Using Access to create reports and queries to a SQL server
>Date: Mon, 30 Jul 2007 14:25:31 -0400
>
>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