accessing a database made in Access..

hey, i want to make a program which will allow me to access a database which is made in access. the database has 3 tables and i want to be able to search 1 table and have it display the relating information in the other 2 tables.
is there a tutorial somewhere that can illustrate such database access (in multiple examples or 1 big one, w/e)?
also, what would be the fastest, most efficient way to search through the database? how do i search through the database? lol if possible i was thinking a binary search tree..thoughts?

thanks :)

Look at ADO (or ODBC) and use SQL to filter the recordset.

>>the database has 3 tables and i want to be able to search 1 table and have it display the relating information in the other 2 tables

IIRC in Access that is a 'query' (in other DBs, ie SQLServer and Oracle, a 'View')


In MFC + ODBC I use the Recordset class and Database class. Can derive a custom recordset from each Access DB table using the MSVC IDE.
Can connect the DB with the app via a (File) DSN. This can be set programatically when the app runs (run a search as I have posted code before).

i program using the win32 api so: would it be hard to switch to MFC? is it worth it to switch?
would it be difficult to convert the code from MFC to win32 api?

thanks :)

>>would it be hard to switch to MFC?

Not if you are using MSVC and C++

i use Dev-C++ 4.9.9.2 lol

i do have MSVC++ 2005 Express Beta installed ? lol but i dont really like using it..