PureBasic Forums - English

Posted: **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

Posted: **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$)

Posted: **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

Posted: **Wed Jul 13, 2005 8:59 pm**

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

Note to myself: Quit drinking...

PureBasic Forums - English

Database Question 2

Database Question 2