How do use Microsoft access embedded database with ODBC?

Question

0.00/5 (No votes)

See more:

I am currently migrating a C++ app using MFC from DAO to ODBC. I have an embedded Microsoft Access database.

It's hard for me to understand what is required to use an embedded Access database with ODBC.
I know that I need a driver, is it the same driver for an embedded and not embedded Access database ? For now I only found this which is supposed to contain a driver for ODBC.
What I am supposed to do then in the OBDC administrator on Windows?
What should I do in Visual Studio C++ to link my app to my database?

Thanks !

What I have tried:

Tried to find infos but I mainly found things about SQL Server which is not embedded. I heard about "file-based mode" but it seems to be related to DSN file and not to database file. I know from the book Access Database Design & Programming by Steven Roman that I need a file-based driver, but I have no idea where to download it and how to use it then.

Posted 11-Dec-17 23:43pm

SheepSpeech

Updated 11-Dec-17 23:47pm

Add a Solution

Comments

[no name] 12-Dec-17 5:56am

~~I think this can be a good starting Point: Connect to data in an Access database (Windows Forms)[^]~~

Leo Chapiro 12-Dec-17 6:07am

The link you shared refers to .NET rather then to C++/MFC?

[no name] 12-Dec-17 6:32am

Thanks for the hint.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Leo Chapiro · Answer 1 · 2017-12-11T23:47:00

Solution 1

Try to use CDatabase Class[^] :

C++

// This fragment is taken from the declaration for CMyDatabaseDoc
// CMyDatabaseDoc is derived from CDocument.
public:
   // Declare a CDatabase embedded in the document
   CDatabase m_dbCust;

   m_dbCust.OpenEx(_T("DSN=MFC_ODBCTest;UID=JOES"));

Posted 11-Dec-17 23:47pm

Leo Chapiro

Comments

SheepSpeech 13-Dec-17 6:35am

And the database will be fully embedded? (The client machines won't need Access ?)