Access .mdb on mobile

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
ddaddy
Posts: 17
Joined: Sun May 15, 2011 5:40 pm

Access .mdb on mobile

Post by ddaddy » Mon May 16, 2011 1:13 pm

I'm only playing around with the trial version of Livecode at the moment, but one of the uses I have in mind is to create a mobile (ios & Android) data entry for an existing MSAccess database.
The Access database is split with the data stored in a .mdb file

Is it possible to access records directly from the .mdb if the .mdb is copied to the device?

Thanks

Klaus
Posts: 14177
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: Access .mdb on mobile

Post by Klaus » Mon May 16, 2011 4:31 pm

Hi ddaddy,

MS Access databases are accessed through ODBC drivers,
if I remember right, and they are not (yet) supported by LiveCode iOS.

Only SQLite and MySQL are currently supported.


Best

Klaus

ddaddy
Posts: 17
Joined: Sun May 15, 2011 5:40 pm

Re: Access .mdb on mobile

Post by ddaddy » Mon May 16, 2011 4:47 pm

Many thanks for the reply.
I guess an alternative method would be to have my access front end export some of the data into a format that could be used on the iOS elbefore going into the field, then have it transfer and convert it back.

Klaus
Posts: 14177
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: Access .mdb on mobile

Post by Klaus » Mon May 16, 2011 5:26 pm

Hi ddaddy,
ddaddy wrote:Many thanks for the reply.
I guess an alternative method would be to have my access front end export some of the data into a format that could be used on the iOS elbefore going into the field, then have it transfer and convert it back.
yep, if that is an option :)


Best

Klaus

Post Reply