?
Solved

How to do Automation of MS Access in MFC.

Posted on 2006-10-30
3
Medium Priority
?
223 Views
Last Modified: 2013-11-12
I want to access MS Access database (.mdb files) through the object model of MS Access Database i.e. tables etc. How to do that.
0
Comment
Question by:sujeet27
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 48

Accepted Solution

by:
AlexFM earned 375 total points
ID: 17842129
0
 

Author Comment

by:sujeet27
ID: 17848172
I want to access tables in the MS Access by (i.e.  .mdb files) by object model of MS Access
 i.e. Automation not by DAO as show in the examples.Can please tell me how to change/read  data in the .mdb files by use of Automation.
0
 

Expert Comment

by:Observer123
ID: 17898273
for example if you use Visual Basic ,  add to the references Microsoft Access 10/...Object Library

after that you can declare varioables from this type :

Dim a As  Access
then use its properties and methods
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explores the difference between two entities: List and Category.   In part one,  we'll look at the basic concepts, and set some groundwork.  In part two, we'll get to some conclusions. I know that these two things are different, but…
Pretext and Context In previous  (http://www.experts-exchange.com/Programming/Theory/Software-Design/A_4457-System-Data-Modeling-Series-Identity-Management-System-Basic-System.html)article, I designed the data model of a basic Identity Management…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question