Visual C++ and Access

Dear All,

I am new in programming with visual C++ and I have a simple question. I have an Access database which I would like to manipulate. The access contains 8 tables. Each table has 5 columns. I would like to inform if is possible to have eight simultaneously recordset open at the same time so be able to read all tables at once. Currently I am using the ODBC (because is the only technique I know). If your answer contains some other solution please include an example of use.

Thanks in advance for your time.




Answer this question

Visual C++ and Access

  • eitanb

    Yeah, no problem. You'd typically use a JOIN query to read data from multiple tables. For MFC examples go here...



  • MarlAtkins

    Thank you Sir.

    To do that i need to made different sql connection string (one for each table) or is it some method which i call and do the rest



  • Visual C++ and Access