Hi! I'm Jovie. I'm having trouble trying to use Sql and Visual Basic 6 select data from one database into a second database. How do you use Sql to access two database at the same time? TIA.
do you mean copying data from one database to another or selecting data from two different databases or selecting data from two different tables?
Scumgrief
This a PHP forum, not Visual basic.
Whcih database are you using?
I mean both. Copying data from one database to another and selecting data from two different database.
Sorry about that. Access.
Why would you want to do that? is the data related...if they are, isn't it easier to put them both in the same database?
definitely. but our networks is not that robust, maintaining a temporary local copy of what you are currently working is safer than across the network saving of data.
hmm..what you mean both of the databases that you want to use is actually the same...
