Thread: view 'relationships' with MS Access as front end

Hello,

I guess what MSAccess calls relationships is only another word for the
definition of foreign keys.

I'm running Postgresql under Ubuntu, accessing it from Windows-machines.
Connecting via ODBC works fine. But I don't see any relationships when
using MSAccess as front-end. When connecting via the OpenOffice JDBC
driver for Postgresql everything is fine.

My colleages - they have to access the database - are very conservative.
Therefore I want to do the same trick with MSAccess.

I'm very new to postgresql and even databases in general, so if this
question doesn't belong to this list, please tell me to which list I
should submit it.

Thanks,
Tom

> I guess what MSAccess calls relationships is only another word for the
> definition of foreign keys.
>
> I'm running Postgresql under Ubuntu, accessing it from Windows-machines.
> Connecting via ODBC works fine. But I don't see any relationships when
> using MSAccess as front-end. When connecting via the OpenOffice JDBC
> driver for Postgresql everything is fine.

What psqlodbc version are you using? Could you try the experimental branch
from Hiroshi? The base download is on pgfoundry.org. The additional
patches is somewhere on the net. You could find the location in
the pgsql-odbc mailing list.

Hiroshi: Why don't you upload this updates to pgfoundry?

> I'm very new to postgresql and even databases in general, so if this
> question doesn't belong to this list, please tell me to which list I
> should submit it.

You're in the right list.

Regards,

Luf