Access 2007 Sample: Developing Access 2007 Solutions with Native C\C++

CREATED RELEASE: Developing Access Solutions Sample Code (Aug 20, 2008)

Wed, 20 Aug 2008 18:14:51 GMT

CREATED RELEASE: Developing Access 2007 Solutions with C or C++ (Aug 20, 2008)

Wed, 20 Aug 2008 17:41:23 GMT

UPDATED WIKI: Home

MSODC — Tue, 19 Aug 2008 21:59:00 GMT

Resource Page Description
These code examples provide detailed information about data access technologies to use when using native C and C++ to develop solutions against the ACE engine. By using data access APIs such as DAO, OLE DB, ADO or ODBC, you can continue to create custom Access solutions for the most complex scenarios. As the default provider for the ACE engine, the Direct DAO driver provides the most comprehensive native interface to Access databases in general. It not only integrates well with the ACE engine, but it is also fast, stable and backward-compatible with the older file formats. As such, DAO is the recommended data access API when developing your Access solutions.

For more information, see the MSDN article titled Developing Access Solutions with Native C or C++:
http://msdn.microsoft.com/en-us/library/cc811599.aspx

Code Examples
This download presents five complete programs created with Microsoft Visual C++ 2008 that are available for download. Source code is compatible with older versions of Visual C++ as well, but you might need to create additional project files for the Visual C++ version with which you want to compile this code.

All programs perform semantically-identical steps by demonstrating syntactical differences in the data access technologies used. Moreover, the console output of each program is almost identical. Examples present the basics of data access, including how to make a connection to a database, and how to work with a recordset on a SQL query.

Here is the list of steps that are performed in each code example:

Define the connection string.
Connect to the C:\Northwind 2007.accdb database.
Verify the connection and display data source name.
Build the SQL query.
Execute the query and create a record set.
Retrieve and display a schema of the record set.
Fetch and display the actual data.
Display the total number of retrieved rows.
Close all handles.
Handle the errors and exceptions where appropriate.

I used similar code to measure an overall speed against these libraries. The performance results are published in the MSDN article as well.

CREATED RELEASE: Developing Access 2007 Solutions with C or C++ (Aug 19, 2008)

Tue, 19 Aug 2008 21:56:00 GMT

UPDATED WIKI: Home

MSODC — Tue, 19 Aug 2008 21:51:59 GMT

Define the connection string.
Connect to the C:\Northwind 2007.accdb database.
Verify the connection and display data source name.
Build the SQL query.
Execute the query and create a record set.
Retrieve and display a schema of the record set.
Fetch and display the actual data.
Display the total number of retrieved rows.
Close all handles.
Handle the errors and exceptions where appropriate.

I used similar code to measure an overall speed against these libraries. The performance results are published in the MSDN article as well.

**Delete the following note before publishing **

This resource page is currently in setup mode and only available to coordinators and developers. Once you have finished setting up your resource page you can publish it to make it available to all MSDN Code Gallery visitors.

To get your Resource Page ready to publish, you should do the following:

Make any changes to the details of your resource page

Here you can enable or disable functions of your resource page. You might want to turn on the Issue Tracker to allow users to provide feedback on your resource, or if you have a resource that does not involve a code sample, you may want to turn off the Releases tab.
Make sure your resource page description is detailed enough to let people search for your resource.

Add your code sample or other resources to the resource page

If you’re uploading code, go to the Releases tab and create a new release to house your code. Creating a release allows you to have the license properly displayed when people download your code, as well as provides a download count.
Edit your Wiki page to attach any resources you may have that are not source code.

If you want to let someone see your resource page before it is published, go to the People tab and add them to your resource page

This will let you add other team members who may be contributing to your resource, or just show it off and get feedback from someone you trust.

Tag your resource page with descriptive tags to make it easier for people to find your resources when browsing the gallery.
Publish your resource page so it becomes visible to everyone!

Additional information on starting a new resource page is available here: Resource Page Startup Guide.