Searching Across Multiple Databases

[JonathanDoe]

I was wondering if there is a way to search across two databases, they would both be hosted on the same server. I was wondering if a search could be done and results would be brought to a page containing info from both databases, and depending on which result you clicked on it would bring you to information from one of the two databases?

Any tips?

[Ribeyed]

hi,
a site I developed for a client had to use Access for the database now the site was about 150 pages but did have thousands of records to start with and about 45 tables. We ended up spiting the tables and using 2 databases, 1 controlling shopping cart, user tracking system etc. and the other one had links to over 6000 url's and 800 companies.
Now it is entirely possible to open connections to both and work on both in the same page. What I haven't done or needed to do is to combine information from one database with information from the other within the web page itself. One of the databases needed a table that was in the other database so I created a linked table in the one so that I can use the information from the table in both databases. I can now create a recordset by using records from 2 tables in 2 different databases. I am not sure if there is a way to do this from within a web page.

Hope this helps.

[JonathanDoe]

Yes thanks that helps, one thing I didnt mention is that I think the two database might be different, one in Access, and one in Lotus Notes if I remember correctly, will this pose a problem?

[Ribeyed]

hi,
yes i think that might cause a problem for you, but i am not sure. My advice would to be go to micrsoft or lotus home pages check out linking tables to different databases, you will soon find out the answer. Sorry i couldn't help more.:(