using multiple database in one program

[raiza]

hi! i'm presently creating a visual basic program which is suppose to be connected in multiple databases.

i've already managed to connect my program to one database in access. however, when i tried connecting another access database to it, it doesn't work.

i made two connections and two recordsets separately for the two database using two adodc but it doesn't work.

is there anything else that i am suppose to add in my codes? is it possible to use multiple access databases in one vb program?

thanks.

[r035198x]

hi! i'm presently creating a visual basic program which is suppose to be connected in multiple databases.

i've already managed to connect my program to one database in access. however, when i tried connecting another access database to it, it doesn't work.

i made two connections and two recordsets separately for the two database using two adodc but it doesn't work.

is there anything else that i am suppose to add in my codes? is it possible to use multiple access databases in one vb program?

thanks.

Please make sure you are posting in the correct forum next time.

What happened when you tried to connect to the other database? Did you get an error? Do you have to be connected to both databases at the same time or is it possible to acheive your requirements by connecting to the databases one at a time?

[werks]

hi! i'm presently creating a visual basic program which is suppose to be connected in multiple databases.

i've already managed to connect my program to one database in access. however, when i tried connecting another access database to it, it doesn't work.

i made two connections and two recordsets separately for the two database using two adodc but it doesn't work.

is there anything else that i am suppose to add in my codes? is it possible to use multiple access databases in one vb program?

thanks.

hi raiza it would be helpful if you could post the exact codes for connecting on your database..


Better Than Yesterday ^^

[lotus18]

I think you are planning to create a distributed dbms.

[debasisdas]

Its better to use ADODB .

try to use two separate connetion object and its related other objects.