2 Databases

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

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

i am using two access databases

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?
>