Migrate from Access 2010 / VBA
feliphil at gmx.net
Sun Nov 25 20:48:16 CET 2012
> I am the lone developer of db apps at a company of 350+ employees.
> Everything is done in MS Access 2010 and VBA. I'm frustrated with the
> limitations of this platform and have been considering switching to
> I've been experimenting with the language for a year or so,
> and feel comfortable with the basics.
> I am concerned that I'll have a hard time replacing the access form
> and report designers. I've worked a little with TKinter, but it's a
> far cry from the GUI designer in Access.
The list of Python frameworks for rapid development of desktop
(i.e. non-Web) database applications currently contains:
using PyQt (& Sqlalchemy):
Sqlkit: sqlkit.argolinux.org (also uses Sqlalchemy)
Defis: sourceforge.net/projects/defis (Russian only)
Pypapi, Camelot, Sqlkit and Dabo seem to be the most active and best
> Finding a professional grade report designer looks like an even
> bigger challenge.
LibreOffice is imho quite useful for database reporting. It comes with a
native (SDBC) driver for PostgreSQL and allows Python scripting.
LibreOffice Base can even be useful for CRUD GUIs.
> I don't need to port any applications, but I will need to use the
> data (mdb/accede format),
Don't. Put your data into an *actually* transaction-safe RDBMS (which
"Jet" is *not*), such as e.g. PostgreSQL.
> design a variety of reports with multi-level groupings, and deliver
> them to many individual recipients via email.
More information about the Python-list