Page 1 of 1

Access .mdb on mobile

Posted: Mon May 16, 2011 1:13 pm
by ddaddy
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

Re: Access .mdb on mobile

Posted: Mon May 16, 2011 4:31 pm
by Klaus
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

Re: Access .mdb on mobile

Posted: Mon May 16, 2011 4:47 pm
by ddaddy
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.

Re: Access .mdb on mobile

Posted: Mon May 16, 2011 5:26 pm
by Klaus
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