Subscribe to this thread
Home - General / All posts - MF 8.x - link table from MS Access
andrej
107 post(s)
#14-Sep-21 08:40

When I want to link the MS Access table (mdb) I get the following error "Can't establish connection to data source: error binding to data source." When I click on the Ok button I get the message "Unknown error." So far, this matter has worked for me for many years. Win 10, MF 8.0.31.0 (x64). Same error if I want to import table from MS Access. Im asking for help. Thanks.


...Don't take life too seriously . No one gets out alive! ...

Dimitri


7,413 post(s)
#14-Sep-21 10:21

Start here: Microsoft Office Formats - MDB, XLS and Friends

Even easier than dealing with the chaos caused by Microsoft's pseudo transition from 32-bits to 64-bits for Office formats, is to just launch Manifold in 32-bits when linking to Office formats.

adamw


10,447 post(s)
#16-Sep-21 12:44

I'll quickly add: the most likely reason you cannot read MDB / XLS / similar data formats in 64-bit mode is that you do not have the 64-bit version of the Microsoft Access Database Engine installed. But read the help topic linked by Dimitri for the details.

andrej
107 post(s)
#17-Sep-21 13:21

The latest Microsoft fixes solved the problem and everything works OK again.


...Don't take life too seriously . No one gets out alive! ...

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.