[clue-tech] MS Access

[David L. Anselmi]

David L. Willson wrote:
> Anyway, does anyone here have an interest in, and some ability
> toward, replacing MS Access apps with open sourcey stuph?  I want a
> hacking partner.  I think the direction to go is OpenOffice.org
> documents over PostgreSQL or MySQL, but I'm not sure.

I looked at OOo.  I hooked it to PostgreSQL easily enough.  But I needed 
a form that could insert into multiple tables and I didn't have time to 
fiddle with it.  What can it do now?

I read a little about Rails.  Figured a web framework might make "slap a 
form on this schema" easy.  Rails seems more general purpose than that. 
  But I think that a web version of Access would be a killer app. 
Everyone I know needs that, but uses Excel instead (one or two know what 
a relation is and then they use Access).  But they all suffer because 
they can't put the front end in front of multiple users.  So I may wind 
up figuring out how to do manual replication of Access.

If OOo is close to Access for making forms, does hooking it to SQLite 
give you the rest of Access?  Just need a macro to create the schema stuff.

> I have a client breathing down my neck about their database upgrade
> and I just can't bring myself to invest more of their money and my
> time in the current MS Access front end.

Why?  If you have it hooked to a real DB what does it suck at?

Dave