Thread: accessing a database made in Access..

  1. #1
    Shibby willc0de4food's Avatar
    Join Date
    Mar 2005
    Location
    MI
    Posts
    378

    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
    Registered Linux User #380033. Be counted: http://counter.li.org

  2. #2
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,868
    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).
    "Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
    Friedrich Nietzsche

    "I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
    George Best

    "If you are going through hell....keep going."
    Winston Churchill

  3. #3
    Shibby willc0de4food's Avatar
    Join Date
    Mar 2005
    Location
    MI
    Posts
    378
    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
    Registered Linux User #380033. Be counted: http://counter.li.org

  4. #4
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,868
    >>would it be hard to switch to MFC?

    Not if you are using MSVC and C++
    "Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
    Friedrich Nietzsche

    "I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
    George Best

    "If you are going through hell....keep going."
    Winston Churchill

  5. #5
    Shibby willc0de4food's Avatar
    Join Date
    Mar 2005
    Location
    MI
    Posts
    378
    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..
    Registered Linux User #380033. Be counted: http://counter.li.org

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Problem aligning floating point numbers
    By esbo in forum C Programming
    Replies: 4
    Last Post: 01-05-2009, 08:09 PM
  2. Error connecting from Dev C++ to MS Access Database
    By Sridar in forum C++ Programming
    Replies: 0
    Last Post: 04-15-2006, 06:09 PM
  3. access to online stock database?
    By genghis in forum Windows Programming
    Replies: 2
    Last Post: 01-23-2003, 03:59 AM
  4. Can i use the ASP to access MYSQL database??
    By Frankiepoon in forum Windows Programming
    Replies: 1
    Last Post: 10-15-2002, 02:37 AM
  5. Database Access
    By bubbajones in forum C++ Programming
    Replies: 1
    Last Post: 09-26-2001, 10:05 PM