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: 505
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
macOS 10.14.2 Mojave, Xcode 10.1, LC 9.0.4, iOS 11.4.1
Targets: Mac, iOS

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 7724
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: 426
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: 505
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
macOS 10.14.2 Mojave, Xcode 10.1, LC 9.0.4, iOS 11.4.1
Targets: Mac, iOS

Simon Knight
Posts: 574
Joined: Wed Nov 04, 2009 11:41 am
Location: Gunthorpe, North Lincs, UK

Re: Reading MS Access MDB

Post by Simon Knight » Wed Jun 17, 2020 8:31 am

AxWald wrote:
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!
Bump!

At the risk of proving that I am not worth my salt has anyone found any information on how to read data from Access files? I have some data only files that do not hold any BLOBs or other tricky stuff and it would be useful to crack them open. I may try and reverse engineer them during lockdown but probably not ;-)

As to the salt issue : there was the compelling reasons of cost why my database is written entirely in MSAccess and trust me I wanted to write the application using Livecode.

best wishes

Simon
best wishes
Skids

matthiasr
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 110
Joined: Sat Apr 08, 2006 7:55 am
Location: Lübbecke, Germany
Contact:

Re: Reading MS Access MDB

Post by matthiasr » Wed Jun 17, 2020 9:44 pm

Simon,

you could connect to your .mdb file from Livecode using ODBC. For Mac OS Actualtech is offering an ODBC driver for Access.
Currently only select and join is supported. Insert and update are not supported. Password protected databases are also not yet supported.
There is a full functioning driver available for download with one exception: It only returns 3 rows.

https://actualtech.com/product_access.php

Regards,
Matthias
Last edited by matthiasr on Thu Jun 18, 2020 8:24 am, edited 1 time in total.

mwieder
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3013
Joined: Mon Jan 22, 2007 7:36 am
Location: Berkeley, CA, US
Contact:

Re: Reading MS Access MDB

Post by mwieder » Wed Jun 17, 2020 11:13 pm

Simon-

It's been a long time, but I have in the past connected to MSAccess databases in the past, so I can confirm that it can be done. I'll dig around in the archives and see if I still have any of the old code.

Simon Knight
Posts: 574
Joined: Wed Nov 04, 2009 11:41 am
Location: Gunthorpe, North Lincs, UK

Re: Reading MS Access MDB

Post by Simon Knight » Thu Jun 18, 2020 8:22 am

Hi,

Thanks to both of you, I'll investigate both suggestions.

Simon
best wishes
Skids

Post Reply

Return to “Databases”