Database Question 2

Maximus_Primal · Post by **Maximus_Primal** » Wed Jul 13, 2005 7:15 pm

Sorry if this is a stupid question but can you open more than one Database file at a time in Pure Basic? I need to access at least 2 or 3 seperate files for the program I am writing (to save having one large and overly complex database). Is this possible or do I need to open each one seperately as required for use at the time?

I am thinking you are limited to one at a time (especially with MDB library).

Can someone tell me if I am right.

Thanks

Max

Num3 · Post by **Num3** » Wed Jul 13, 2005 7:27 pm

You can open multiple database connections at once...

Code: Select all

Result = OpenDatabase(#Database1, ODBCDatabaseName$, User$, Password$) 
Result = OpenDatabase(#Database2, ODBCDatabaseName$, User$, Password$) 
Result = OpenDatabase(#Database3, ODBCDatabaseName$, User$, Password$)

Maximus_Primal · Post by **Maximus_Primal** » Wed Jul 13, 2005 7:44 pm

Oh right.... I was looking in the wrong place obviously. Sorry for asking such a stupid question and thanks for the simple answer.

Max

Num3 · Post by **Num3** » Wed Jul 13, 2005 8:59 pm

He who does not ask, will not find the answer ...

Note to myself: Quit drinking...