hi,<BR><BR> Is it possible to make relation between two table of different ms access database and display the details in asp pages?<BR><BR>regards<BR>raj74
Honestly, you can't.<BR><BR>RAJ.
It depends on the data you are using and what you are trying to do..
Almost trivial.<BR><BR>Make connection to first DB. Then use SQL like:<BR><BR>SELECT T1.name, T2.order<BR>FROM table1 AS T1, table2 IN 'c:path ootherdatabase.mdb' AS T2<BR>WHERE T1.whatever = T2.something<BR><BR>
...is use Access to create or enforce the relationship. You have to do that external to Access. Though even in Access you can execute a SQL query that links the two DBs.<BR><BR>