[mdb-dev] Re: Newbie with lots of questions

[Seb <sp...@gm...>]

Ross Johnson <Ros...@ho...> wrote:

[...]

> I've found OOo Base together with PostgreSQL via the PostgreSQL.org
> JDBC3 driver works very well. Whichever database you choose, most/all of
> the GUI Query Designer works as does the Forms designer, or you can
> write pass-through queries to access database-specific features if you
> want. I've just completed a large job using these components building an
> application that includes over 800 form controls spread over a dozen or
> more forms. I used mdb-tools to migrate the Access data to PostgreSQL.

Thanks for the corrections, OOo Base seems to have come a long way since I
last delved into this.  Sounds as if it's worth a try for sure!

I don't know how PostgreSQL works, as I've already chosen MySQL some time
ago, but were you able to migrate your Access relationships?  If you were,
could you please point out the procedure, if it's not a hassle?

I was able to migrate all my Access tables to MySQL with mdb-tools, but
had to reconstruct relationships on a per-query basis afterwards.  I'm
still learning MySQL, so I'm not even sure it supports a system of
relationships in the sense that Access does.


-- 
Seb