Connect to Microsoft Access

[alnux]

hi @jcheron is there any way to connect to a microsoft access db by odbc ??? thanks

[jcheron]

Hi @alnux ,
no, the pdo wrapper for odbc has not yet been implemented.
And it's not necessarily easy, since ODBC is multi-provider.

[alnux]

ok @jcheron so can i ask if you know how can i connect to a ms access db some php library and how can i use it with ubiquity over windows 10. thanks

[jcheron]

No, I'm not aware of any such library.
If you really need it, maybe we can implement a specific ODBC Access wrapper.

[jcheron]

I'm having problems implementing the wrapper for Access:

• Can't get the list of primary keys for a table
• Can't get the list of foreign keys

I still have a problem with access rights to system tables that I can't resolve.