Subscribe to this thread
Home - General / All posts - linking tables through odbc - M9 --> ms-access
yves61
320 post(s)
#22-Nov-21 08:45

I am trying to link M9 tables in Ms-Access.

With M9 ODBC activatedand M9 (v 175.5) project closed, I run Ms_access.

From within Ms-Access I connect through M9 odbc to my M9 project, willing to link to tables in M9.

Connection is established. On opening the linked table(s) the records and fields show "#verwijderd" (= "deleted"). Check attached file odbc_onLinkingTable.png

-

But on importing the tables everything runs fine. Check attached file odbc_onImportingTable.png

-

Any ideas what I need to adapt in order to link tables correctly ?

-

Added : running Microsoft® Access® voor Microsoft 365 MSO (Versie 2110 Build 16.0.14527.20270) 64 bits

Attachments:
odbc_onImportingTable.PNG
odbc_onLinkingTable.PNG

yves61
320 post(s)
#25-Nov-21 18:51

Anyone able to help me with the above question ?

Any ideas what I need to adapt in order to link tables correctly (from within Ms-Access link to table in Manifold .map )?

-

yves61
320 post(s)
#25-Nov-21 19:55

OK.

Searched the forum a little more and found this thread which helped me out;

https://georeference.org/forum/t143177#143375 . Thanks to Adam.

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