Hello,

I need to create linked table in a mdb (or accdb) file.
These linked tables sources can be csv files, sql server table or other
if I have the odbc driver (sage for instance).

How can I do this ?

Thanks for any suggestion.

--
Fred
(E-Mail Removed)

I do not know why you ask this question here in ADO.NET NG.

You only need and do linked table when you use MS Access as front-end
application (so you will not use .NET stuff with it). You start MS Access,
go to menu "Files->Get External Data->Linked Tables..." to link this front
end to a back end data source (ODBC data source).

"Fred" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I need to create linked table in a mdb (or accdb) file.
> These linked tables sources can be csv files, sql server table or other if
> I have the odbc driver (sage for instance).
>
> How can I do this ?
>
> Thanks for any suggestion.
>
> --
> Fred
> (E-Mail Removed)

"Fred" <(E-Mail Removed)> a écrit dans le message de
news:(E-Mail Removed)...
> Hello,
>
> I need to create linked table in a mdb (or accdb) file.
> These linked tables sources can be csv files, sql server table or
> other if I have the odbc driver (sage for instance).
>
> How can I do this ?


I didn't find something else than using a com reference to ADOX which is
what I wanted to avoid.
Never mind. I finally used another way.

--
Fred
(E-Mail Removed)

There are many free resources available online -- simply search on
some combination of "odbc linked tables from MS Access".

--Mary

On Wed, 8 Apr 2009 10:25:14 +0200, "Fred" <(E-Mail Removed)>
wrote:

>Hello,
>
>I need to create linked table in a mdb (or accdb) file.
>These linked tables sources can be csv files, sql server table or other
>if I have the odbc driver (sage for instance).
>
>How can I do this ?
>
>Thanks for any suggestion.

I hope you don't expect this to work very well. While it's possible to link
tables into an Access/JET database, the JET engine does not handle them
particularly efficiently.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________



"Mary Chipman [MSFT]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> There are many free resources available online -- simply search on
> some combination of "odbc linked tables from MS Access".
>
> --Mary
>
> On Wed, 8 Apr 2009 10:25:14 +0200, "Fred" <(E-Mail Removed)>
> wrote:
>
>>Hello,
>>
>>I need to create linked table in a mdb (or accdb) file.
>>These linked tables sources can be csv files, sql server table or other
>>if I have the odbc driver (sage for instance).
>>
>>How can I do this ?
>>
>>Thanks for any suggestion.

Not necessarily, you just have to understand what you're doing. See
Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx. It gives you
the lowdown on how to use Jet efficiently, which is basically the same
rule of thumb as for any client-server application -- fetch only
needed data; don't "link" to the whole megilla. Used correctly, Jet
gives you a lot of flexibility (basically you can use it to cache data
on the client machine, much the same way you'd use a DataSet, except
with a decent query engine and the ability to persist it, if desired).

Stephen Forte and I are co-presenting a session at TechEd this year,
DAT312, "Solve Problems without Spending Money: Access and SQL Server"
in which we'll cover using Access as a front-end to SQL Server data to
solve various business problems when there isn't a need (or there
aren't the resources) to develop a full-fledged .NET app. See
http://www.msteched.com/sessionlist/default.aspx for details.

--Mary

On Thu, 9 Apr 2009 09:18:33 -0700, "William Vaughn \(MVP\)"
<(E-Mail Removed)> wrote:

>I hope you don't expect this to work very well. While it's possible to link
>tables into an Access/JET database, the JET engine does not handle them
>particularly efficiently.