Thread: Microsoft Access and C++

  1. #1
    Registered User
    Join Date
    Dec 2014
    Location
    Mayaguez, Puerto Rico, Puerto Rico
    Posts
    12

    Microsoft Access and C++

    Hello friends. I need a push in the right direction concerning extracting data from databases, especially microsoft access. Let's say I have this dictionary database in Access and I want to write a code in C++ that goes through all the words in the database and extracts specific words like palindromes and stores it in a list or vector. What headers would I use? What would be the syntax for extracting from the database? Anybody knows of a tutorial? Your help would be much appreciated and if I get a "........ off" I understand and wont take it personal. I assume its probably hard and time consuming to explain.

  2. #2
    Registered User
    Join Date
    Mar 2015
    Posts
    184
    I suppose I'd start with researching the format, binary or txt, does it have comma delimiters etc.

  3. #3
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    38,314
    The key phrase to know is odbc (open database connectivity)
    https://www.google.co.uk/search?q=mi...t+odbc+c%2B%2B
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

  4. #4
    Registered User
    Join Date
    May 2011
    Location
    Around 8.3 light-minutes from the Sun
    Posts
    1,949
    Depending on your needs, the right tool for the job may be shifting to a managed language such as C# or VB.NET. Both of these language wrap the COM interface nicely and allow for easier db access. Otherwise browse through the links Salem provided and you will see examples of connecting to access from C++. If you are using Microsoft visual studio there is a wizard to add a datasource that simplifies things as well.
    Quote Originally Posted by anduril462 View Post
    Now, please, for the love of all things good and holy, think about what you're doing! Don't just run around willy-nilly, coding like a drunk two-year-old....
    Quote Originally Posted by quzah View Post
    ..... Just don't be surprised when I say you aren't using standard C anymore, and as such,are off in your own little universe that I will completely disregard.
    Warning: Some or all of my posted code may be non-standard and as such should not be used and in no case looked at.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. c# and Microsoft access
    By -Od|n- in forum C# Programming
    Replies: 9
    Last Post: 09-11-2009, 08:19 AM
  2. Creating new records in Microsoft Access
    By ulillillia in forum Tech Board
    Replies: 2
    Last Post: 12-22-2008, 12:12 PM
  3. microsoft access problem
    By ElastoManiac in forum A Brief History of Cprogramming.com
    Replies: 13
    Last Post: 12-05-2005, 07:42 AM
  4. reading *.mdb ( microsoft access )
    By ElastoManiac in forum C++ Programming
    Replies: 7
    Last Post: 12-01-2005, 03:44 PM
  5. Microsoft Access problem
    By Micko in forum Tech Board
    Replies: 7
    Last Post: 03-04-2005, 01:55 AM