reading *.mdb ( microsoft access )

This is a discussion on reading *.mdb ( microsoft access ) within the C++ Programming forums, part of the General Programming Boards category; So how to read it. I just have one table in database, and i wanna read fields from that table, ...

  1. #1
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377

    Question reading *.mdb ( microsoft access )

    So how to read it. I just have one table in database, and i wanna read fields from that table,
    very simple table.
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  2. #2
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    And the table is very very large, But that doesn't have to do with anything, does it?
    ( it's about 6MB )
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  3. #3
    Registered User
    Join Date
    Aug 2005
    Posts
    1,267
    you have to use database operations techniques, such as ODBC or ADO, and you have to know SQL (structured query language). There are lots of books on all these subjects -- not for beginners. If you google around you will find some ODBC c++ classes to make it a little easier.

    And SQL language is not standardized. What works on one database may or may not work on others. There is a basic set of SQL commands, but beyond that each database has its own unique set of SQL functions.
    Last edited by Ancient Dragon; 12-01-2005 at 09:00 AM.

  4. #4
    the hat of redundancy hat nvoigt's Avatar
    Join Date
    Aug 2001
    Location
    Hannover, Germany
    Posts
    3,139
    Without any information on what your resources are, I would suggest you use the MFC CDatabase/CRecordset classes und Access as an ODBC Datasource.
    hth
    -nv

    She was so Blonde, she spent 20 minutes looking at the orange juice can because it said "Concentrate."

    When in doubt, read the FAQ.
    Then ask a smart question.

  5. #5
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    I'm not gonna use MFC
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  6. #6
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    ODBC is commercial!
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  7. #7
    semi-colon generator ChaosEngine's Avatar
    Join Date
    Sep 2005
    Location
    Chch, NZ
    Posts
    597
    Quote Originally Posted by ElastoManiac
    ODBC is commercial!
    and wtf do you think access is?
    ODBC = OPEN database connectivity.
    it's actually an open standard USED by commerical products.

    Unless you really like writing a tonne of code to read the mdb file by hand (if you are daft enough to attempt this here's the MDB file format), ODBC is your friend. You can use MFC classes, ADO, DAO, ADO.net.

    here go learn SQL and try to avoid making statements like that in the future.

    "Better to keep silent and be thought a fool, then to open your mouth and remove all doubt"
    "I saw a sign that said 'Drink Canada Dry', so I started"
    -- Brendan Behan

    Free Compiler: Visual C++ 2005 Express
    If you program in C++, you need Boost. You should also know how to use the Standard Library (STL). Want to make games? After reading this, I don't like WxWidgets anymore. Want to add some scripting to your App?

  8. #8
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    this is getting too complicated, i'm just gonna extract my table to *.txt and read it with <fstream>
    Althought it would be very nice if i'v learned how to handle this stuff.
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. ww hosting and SSH access
    By spoon_ in forum A Brief History of Cprogramming.com
    Replies: 9
    Last Post: 04-07-2005, 09:49 AM
  2. Microsoft Access problem
    By Micko in forum Tech Board
    Replies: 7
    Last Post: 03-04-2005, 01:55 AM
  3. Apps that act "differently" in XP SP2
    By Stan100 in forum Tech Board
    Replies: 6
    Last Post: 08-16-2004, 11:38 PM
  4. The future of Microsoft
    By Liger86 in forum A Brief History of Cprogramming.com
    Replies: 9
    Last Post: 12-05-2003, 10:01 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21