Can I connect to the MS Access object model?

  • 1
  • Question
  • Updated 10 months ago
How to connect to MS Access from MindManager 2017 via VBA to create a table or query in MS Access?
those. MindManager 2017 -> VBA -> MS Access
Photo of Ivan

Ivan

  • 41 Posts
  • 0 Reply Likes

Posted 10 months ago

  • 1
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1251 Posts
  • 189 Reply Likes
Have you tried the built-in Database Connector?

You can find it under the advanced tab. If not visible, you can switch it on via

File => Options=> Addins and tick the box.

There is an example database where you can play with.
Do that.
It helps you understand what can be done and what the limitations are.

Succes
(Edited)
Photo of Ivan

Ivan

  • 41 Posts
  • 0 Reply Likes
I attach materials that relate to working with databases:
    - See the screen.
    - link .

That's all I found.
If I understand correctly, these tools only extract data from the database.

And how to make that I could create in Access a query or a table?


 
ps
I apologize if I ask an incorrect question. So far I'm only a programmer.







(Edited)
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1251 Posts
  • 189 Reply Likes
I see your link is to MindManager 2012 help.
You have MM 2017, i presume?

The help for that version is here:
http://onlinehelp.mindjet.com/help/Mindmanager/17_1/EN/mindmanager_help.htm

Look for Database linker.

It is a 2-way connection, so you can read AND write to the databse, but it will not create your tables from MindManager.

Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1251 Posts
  • 189 Reply Likes
There is no need to create a query in Acces since you can do this in MindManager.
Photo of aHa!Coaching

aHa!Coaching, Champion

  • 1192 Posts
  • 116 Reply Likes
You should be able to use ADO in MindManager's Macro editor. To do this, first add the correct reference (see screenshot) and get started with the sample code from this article: https://analysistabs.com/excel-vba/ado-sql-macros-connecting-database/