Re: Access VBA Migration

Gregory L. Magnusson wrote:

> Hello all,
>
> I am wondering, can anyone comment on the following statement
> regarding migration of Access applications out of Access?
>
> "The biggest problem with migrating from Access to some other database
> isn't the database data itself (the tables, data, and separate
> queries), it's the fact that people have used it to create
> applications; Access includes a built-in VBA runtime that people use
> to create forms and create reports. Many of the queries and updates
> are "bound" to controls on the forms. It's those forms, bound queries,
> and reports that get lost when you migrate an Access application out
> of Access--and I don't think MySQL has done or can do anything to
> solve that problem. "
>
> Any and all information will be appreciated,
>
> Greg Magnusson
> [email protected]
>
>
This is certainly the reason why people choose to stick with Access -
it's a whole ecosystem of tools.
Luckily, help is on the way :)

Have a look at:
http://entropy.homelinux.org/axis_not_evil

It's a Perl project I've started to provide a database-aware RAD
development environment under Linux ( but it works on Windows and OS-X
as well ). You use Glade to build the GUI, in a similar fashion to using
Access' form designer ( but better ).

Then for forms, you create a Gtk2::Ex::DBI object, give it your SQL from
the query you want to 'bind' and point it at your Glade-generated form.

I've also got Gtk2::Ex::Datasheet::DBI for datasheets, and
PDF::ReportWriter for reports.

I've ported 3 *major* applications from Access to Gtk2-Perl in with
these modules ( tested heavily ), and while I wouldn't exactly say that
it was an 'instant' migration, it's really just a matter of redesigning
your GUI in Glade ... which is fun and produces much better looking
forms ... and rewriting your VB code ( or God forbid ... macros ) in
Perl ... which is also quite fun and much more powerful than VB.
Honestly, after a week of designing stuff with Gtk2-Perl, you won't want
to look back at Access, apart from the occasional laugh.

The project is being actively developed, so feel free to send feature
requests, comments, patches, etc.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [email protected]
website: http://www.nusconsulting.com.au

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]