Page 1 of 1
Access
Posted: Wed Aug 24, 2011 6:37 pm
by melhiatt
If I have a database in access, is it possible to transfer that information in and keep the functionality of forms and reports?
Re: Access
Posted: Wed Aug 24, 2011 11:40 pm
by dglass
Does 'transfer that information in' mean move it to another database?
Theoretically, you could put it into something else (SQLite, for instance), and connect to it in Access via ODBC, provided you have the proper ODBC driver for the new database engine.
Re: Access
Posted: Thu Aug 25, 2011 1:12 am
by Steve Denney
Hi, Access is an odbc database.
You can construct SQL statements in your livecode app and have them executed by Access. Livecode's database library also includes a number of useful commands & functions (all starting with revdb).
So...
Transfer that information in? Definitely, you can import your Access database into your app and display it in any fashion you choose. You can update, edit, delete, sort, search (and more) your database. This goes both ways, meaning you can change the data in Access too.
Keep the functionality of forms and reports? Not sure. Presumably you could write SQL to duplicate said forms/reports, but that’s hardly keeping them.
Steve