Preferred Access ODBC Linking Method -- sql server odbc

Sue Hoegemeier
3/27/2006 8:39:56 PM

So the answer you get to that in a SQL Server newsgroup is
neither. I'd prefer that linked tables not be used - a front
end should use stored procedures to access the data.
However, your probably are more interested in which way to
do your code to link tables so try posting in one of the
Access newsgroups such as:
microsoft.public.access.odbcclientsvr

-Sue

On Wed, 22 Mar 2006 08:00:30 -0800, DBG
[quoted text, click to view]

DBG
3/28/2006 7:17:01 AM

Actually, I posted there as well and the response was essentially, it one is
not specifically more or less efficient except for the amount of code they
physically use to make the connection.

I agree, I am rarely using linked tables, and for the most part using
pass-through queries, stored procedures, and local tables which are updated
from SQL sever.

-David

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : Preferred Access ODBC Linking Method