Link Tables to SQL Server via ADO instead of ODBC?

[smedvid]

Just curious when you create a linked table via the Wizard in MS Access, it appears to be using the ODBC connectivity.

I would prefer to use ADO/OLEDB. Has anyone doen this?

tia,



Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[BNPMike]

Steve

I don't know the answer to your question but I note no-one else has volunteered anything else so far.

Access is really very good at collecting data from all sorts of different places. It does however rely on ODBC. Indeed I think ODBC was Microsoft's strategy for allowing things in general, and Access in particular, to allow universal data access.

My point is "why fight it?". Do you really need ADO/OLEDB?

 

[cmmrfrds]

I don't believe so.

What is the main reason you do not want to link tables with odbc. overhead? error handling? setting up the odbc on each client?