On Sun, 25 Oct 1998, D'jinnie wrote: > :If you are one of those extravagent people who has more than one > :computer, you could always run something like PostgreSQL or mySQL and > :use their ODBC drivers to use them as a backend, but do all your > :database design on Access... I'm thinking of doing this myself at the > :moment with my homicide database, but I'm still trying to work out how > :to tell mySQL that my other computer is allowed to connect to it... > > I have attempted to set up ODBC with Postgres, and I think I got the ODBC > part working (I'm doing this for my work, trying to come up with an > alternative to M$ SQL :) but I've no clue how to make Access talk to > Postgres...if anyone got this working, I would appreciate any and all > hints and suggestions :)
IIRC, M$ Access will output plain boring SQL, which I guess Postgres could read... Matthew -- Elen sila lumenn' omentielvo Steward of the Cambridge Tolkien Society Selwyn College Computer Support http://www.geocities.com/Area51/Chamber/8841/ http://www.cam.ac.uk/CambUniv/Societies/tolkien/ http://pick.sel.cam.ac.uk/