how to access data from 2 different sources?

[djc]

I need to use data from multiple tables that are located in 2 different
databases. Most of the tables are in SQL Server 2000 but 1 one the tables I
need to include in my query resides in an Access2002 mdb file.

I need to do this via ASP/ADO on IIS5.

How do I combine (join in a query) tables from different databases? they
are each opened from a different connection object? I have only had to
access tables from one source before and I used the recordset.Open "sql
statement", connectionObjectVariable syntax.

Can I this even be done?

any help is appreciated. Thanks.

[Madjid Z.]

One quick way, is to setup a dummy access db, and use odbc
to connect to both the original access db and sql server,
and link the tables you like. Now you'd have the tables
under "one roof", and do whatever with them!

[djc]

Thanks for the reply. I probably will do that if I can't find a way to do it
through internet explorer and asp/ado. I really would like to do it that
way.

But thanks for the option.

"Madjid Z." <anonymous@discussions.microsoft.com> wrote in message
news:042001c39805$b9a6a330$a101280a@phx.gbl...

>
> One quick way, is to setup a dummy access db, and use odbc
> to connect to both the original access db and sql server,
> and link the tables you like. Now you'd have the tables
> under "one roof", and do whatever with them!

You can create a linked server to access database in sql
server and then you can write your standard sql statement.

Let me know if you need more info.

>-----Original Message-----
>Thanks for the reply. I probably will do that if I can't

find a way to do it

>through internet explorer and asp/ado. I really would

like to do it that

>way.
>
>But thanks for the option.
>
>"Madjid Z." <anonymous@discussions.microsoft.com> wrote

in message

>news:042001c39805$b9a6a330$a101280a@phx.gbl...

>>
>> One quick way, is to setup a dummy access db, and use

odbc

>> to connect to both the original access db and sql

server,

>> and link the tables you like. Now you'd have the tables
>> under "one roof", and do whatever with them!

>
>
>.
>

[djc]

will do. Thanks.

<anonymous@discussions.microsoft.com> wrote in message
news:027301c398dc$10dcaab0$a501280a@phx.gbl...

> You can create a linked server to access database in sql
> server and then you can write your standard sql statement.
>
> Let me know if you need more info.
>

> >-----Original Message-----
> >Thanks for the reply. I probably will do that if I can't

> find a way to do it

> >through internet explorer and asp/ado. I really would

> like to do it that

> >way.
> >
> >But thanks for the option.
> >
> >"Madjid Z." <anonymous@discussions.microsoft.com> wrote

> in message

> >news:042001c39805$b9a6a330$a101280a@phx.gbl...

> >>
> >> One quick way, is to setup a dummy access db, and use

> odbc

> >> to connect to both the original access db and sql

> server,

> >> and link the tables you like. Now you'd have the tables
> >> under "one roof", and do whatever with them!

> >
> >
> >.
> >