Geek Answers Handbook

Connect to a Microsoft Access database with Xcode

I was tasked with writing a Mac application in xcode 4.3 that can search and display data from the MS Access public database, which is regularly updated. For this reason, I cannot just convert the file to another database platform. I searched the depths of Google and cannot find anyone else trying to accomplish such a task.

Can someone point me in the right direction?

+5
source share
2 answers

You can try using third-party tools that provide connectivity, for example, actualtech. http://www.actualtech.com/product_access.php
I personally have never tried this one, but it looks promising.

I believe that there is no native Microsoft support for platforms other than Windows.

+2
source

If the database is in an MDB file, you can try using this MDB to MySQL converter .

You can write a daemon that retrieves the last SQL dump daily or even hourly and saves it in a local SQLite file. Then your client application just needs to request a local file.

I know that this is not as convenient as a direct connection to the database, but this is a "free" solution.

0
source

More articles:


All Articles