Reading MS Access MDB

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
marksmithhfx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 461
Joined: Thu Nov 13, 2008 6:48 am
Location: Winnipeg, Manitoba

Reading MS Access MDB

Post by marksmithhfx » Wed Apr 19, 2017 3:30 am

Any current instructions/lessons/examples around of reading an MS Access MDB from Livecode?
Oh I should add, for Mac please.
Thanks in advance
Mark
Mac OS 10.12.1, Xcode 8.0, LC 8.1.1, iOS 9.3.5
Targets: Mac, iOS

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 5342
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Reading MS Access MDB

Post by FourthWorld » Wed Apr 19, 2017 5:24 am

Interesting question. Has Microsoft released any of the Access code as open source?
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

AxWald
Posts: 284
Joined: Thu Mar 06, 2014 2:57 pm

Re: Reading MS Access MDB

Post by AxWald » Wed Apr 19, 2017 8:55 am

Hi,

use ODBC to connect to MS Access databases: Wiki. Reading from the .mdb itself can be done (via "read from file" ...), but the file structure is rather sophisticated. And if the Access coder is worth its salt, the data you're looking for aren't in it, anyways ;-)

Richard, don't think so. MS Access is a crucial part of MS' "enterprise ecosystem" (as front end to MS SQL), and this is where the money is made. It's even not included in the basic MS Office versions, you have to buy it separately.

Have fun!
Livecode programming until the cat hits the fan ...

marksmithhfx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 461
Joined: Thu Nov 13, 2008 6:48 am
Location: Winnipeg, Manitoba

Re: Reading MS Access MDB

Post by marksmithhfx » Thu Apr 20, 2017 2:21 am

Axwald, thanks for the quick reply and useful information. Much appreciated

Mark
Mac OS 10.12.1, Xcode 8.0, LC 8.1.1, iOS 9.3.5
Targets: Mac, iOS

Post Reply

Return to “Databases”