Hello all,

I'm neighter a newbie nor an experimented rubyist and I've got a
"general" question. At work, we use a relatively big MS-Access
front-end application (with MS-SQL Server as back-end). It is really a
pain to debug this application and to add functionnaly because it is
poorly design... and the language (VBA) is quite limited and
proportionnaly frustrating.

What I'd like, it's to change things and use Ruby to do some work. A
kind of programming interface between MS-Access and SQL-Server to
remove complex parts for VBA and use Ruby instead. I cannot rebuild
this big application from scratch (200+ forms, 200+ queries, 200+
tables, 100+ reports) so I have to live with some important constaints.


Can I use ruby to do a part of the job, a kind of dll or, even better,
a way that would keep state between different call?

Any suggestion would be appreciated.

Yannick