Reading MS Access MDB

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Reading MS Access MDB

Postby 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
marksmithhfx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 459
Joined: Thu Nov 13, 2008 6:48 am
Location: Winnipeg, Manitoba

Re: Reading MS Access MDB

Postby 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/
FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 5098
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles

Re: Reading MS Access MDB

Postby 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 ...
AxWald
 
Posts: 267
Joined: Thu Mar 06, 2014 2:57 pm

Re: Reading MS Access MDB

Postby 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
marksmithhfx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 459
Joined: Thu Nov 13, 2008 6:48 am
Location: Winnipeg, Manitoba


Return to Databases

Who is online

Users browsing this forum: No registered users and 1 guest