We help IT Professionals succeed at work.

How to do Automation of MS Access in MFC.

sujeet27
sujeet27 asked
on
Medium Priority
239 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.
Comment
Watch Question

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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.
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.