2 Databases

[acidrain9]

i have 2 access databases that i need to connect to.... normally not a problem but what i am trying to do is basically create a recordset with both databases. the databases are related...basically database2 has a field with the ID of the corresponding record in database1.
anyone have any ideas?

[Newsgroup_User]

Access or SQL Server?

Drew

"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:ekpetc$4db$1@forums.macromedia.com...
>i have 2 access databases that i need to connect to.... normally not a
>problem
> but what i am trying to do is basically create a recordset with both
> databases.
> the databases are related...basically database2 has a field with the ID of
> the
> coresponding record in database1.
> anyone have any ideas?
>

[acidrain9]

i am using two access databases

[Newsgroup_User]

Is there a reason why you are using two databases?


"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:ekpujq$moo$1@forums.macromedia.com...
>i am using two access databases

[Newsgroup_User]

If you are using ASP as your server language you are very limited in what
you can achieve. In ASP.Net however it is fairly simple. You would suck the
data for ach recordset into a data table, define the relationships between
the two and then you could create a dataview that would essentially be the
same as if the records came from the same database.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:ekpujq$moo$1@forums.macromedia.com...
>i am using two access databases