[AccessD] How Access actually accesses SQL Server data

Oh yea!  It is amazing how Access actually gets data from SQL Server.  In the case of updates it is 
way inefficient and native stored procedures should be considered where possible.  Really quite 
fascinating.

It is too bad that there isn't a way to set a property turning on the logging thing though. 
Modifying the registry every time (and remembering to turn it back off) is very clumsy for something 
so potentially useful.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 1/19/2012 8:06 AM, Jim Dettman wrote:
>
>   Yeah, anyone that works with Access and SQL should give it a good read
> through.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, January 19, 2012 06:51 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] How Access actually accesses SQL Server data
>
> Oh, you want to *read* it.  :)
>
> http://msdn.microsoft.com/en-us/library/bb188204%28v=sql.90%29.aspx
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 1/19/2012 12:18 AM, Charlotte Foust wrote:
>> Um, did you forget the link, John?
>>
>> Charlotte Foust
>>
>> On Wed, Jan 18, 2012 at 9:04 PM,
> jwcolby<jwcolby at colbyconsulting.com>wrote:
>>
>>> A fascinating read, which IIRC has been presented here before but I just
>>> stumbled across it again.
>>>
>>> --
>>> John W. Colby
>>> Colby Consulting
>>>
>>> Reality is what refuses to go away
>>> when you do not believe in it
>>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>>
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadviso
> rs.com/mailman/listinfo/accessd>
>>>
>>>
>>> Website:
> http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>>
>>>
>>>
>