Reading MS Access MDB

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
marksmithhfx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 931
Joined: Thu Nov 13, 2008 6:48 am
Location: London, UK

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 12.6.5 (Monterey), Xcode 14.2, LC 10.0.0, iOS 15.6.1
Targets: Mac, iOS

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 9801
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
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

AxWald
Posts: 578
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!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!

marksmithhfx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 931
Joined: Thu Nov 13, 2008 6:48 am
Location: London, UK

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 12.6.5 (Monterey), Xcode 14.2, LC 10.0.0, iOS 15.6.1
Targets: Mac, iOS

Simon Knight
Posts: 845
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: 190
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: 3581
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: 845
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”