|
Home > Archive > MS SQL Server ODBC > March 2006 > Preferred Access ODBC Linking Method
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Preferred Access ODBC Linking Method
|
|
|
| Is the preferred Access 2003 method CreateTableDef or TransferDatabase and why?
Thanks!
-David
| |
| Sue Hoegemeier 2006-03-28, 3:23 am |
| 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
<DBG@discussions.microsoft.com> wrote:
>Is the preferred Access 2003 method CreateTableDef or TransferDatabase and why?
>
>Thanks!
>
>-David
| |
|
| 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
"Sue Hoegemeier" wrote:
> 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
> <DBG@discussions.microsoft.com> wrote:
>
>
>
|
|
|
|
|