By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,375 Members | 3,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,375 IT Pros & Developers. It's quick & easy.

using multiple database in one program

P: 1
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.
Jan 28 '08 #1
Share this Question
Share on Google+
4 Replies


10K+
P: 13,264
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?
Jan 28 '08 #2

werks
100+
P: 220
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 ^^
Jan 28 '08 #3

lotus18
100+
P: 866
I think you are planning to create a distributed dbms.
Jan 28 '08 #4

debasisdas
Expert 5K+
P: 8,127
Its better to use ADODB .

try to use two separate connetion object and its related other objects.
Jan 28 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.