Access database connection

  • 1
  • Question
  • Updated 6 years ago
  • Answered
I could not estabilish a connection to an ACCESS DATABASE. I don't know why. The database works well.

What I have to do?

thanks!
Photo of Cidadão Ativo

Cidadão Ativo

  • 7 Posts
  • 0 Reply Likes

Posted 6 years ago

  • 1
Photo of Esther van Wijngaarden

Esther van Wijngaarden

  • 154 Posts
  • 61 Reply Likes
What error do you get?
When you go to File>Options and select Database you can select the database and test the connection.
Photo of Cidadão Ativo

Cidadão Ativo

  • 7 Posts
  • 0 Reply Likes
Hi Esther, thanks for the answer!

I have a folder with some small acess databases, made with Microsoft Access 2010, in accdb format.

I choose the connection type MICROSOFT ACCESS 2007-2010, and selected the file, but the test go wrong.



The database works fine in Access. I tried changing the name of the connection, but it did not work.

I use Mindjet Mindmanager Pro 2012. My system is Windows Vista 64 bits.
Photo of Esther van Wijngaarden

Esther van Wijngaarden

  • 154 Posts
  • 61 Reply Likes
Can you connect to the sample database that is included in MindManager (C:\Users\USERNAME\AppData\Local\Mindjet\MindManager\10\Database Linker\SampleDatabase.mdb?

If not, please contact Mindjet Support. Connecting to a local Access database is a simple connection and should always work.

I am not sure if the database connection is working in the 64 bits version.
Photo of Cidadão Ativo

Cidadão Ativo

  • 7 Posts
  • 0 Reply Likes
Yes, the connection to the sample database is OK. It is in MDB (2003) format.

I made some tests, creating new databases in format 2003 (mdb) and 2007 (accdb). In all cases, the connection is completed with the mdb databases. But it is not possible to connect to the accdb databases.

Maybe I need to change some configuration in Access. I already did it, changing many configuration in the TRUSTED CENTER, but still it is not possible to connect with the databases in 2007 format.

Esther, do you have connections with 2007 databases in your computer?
Photo of Esther van Wijngaarden

Esther van Wijngaarden

  • 154 Posts
  • 61 Reply Likes
Yes, I have some very simple .accdb (2007) databases and can connect to MindManager.
But I have Windows 7 32 bits.
Photo of Cidadão Ativo

Cidadão Ativo

  • 7 Posts
  • 0 Reply Likes
Since I tried all configurations in the trusted center of Access, I think Mindmanager 2012 can not connect to access databases in 2007 format, if the sistem is 64 bits.

I also use another computer, with windows 7, but is 64 bits too. Microsoft Office is in the computer with Vista 64.

The databases I plan to use with Mindmanager are all simple, then the solution will be to convert them to 2003 format. I will write Mindjet support to fix this issue in future versions of Mindmanager.

Thank you very much, Esther!! I appreciate your help.

This conversation is no longer open for comments or replies.