Re: [GENERAL] ODBC, access, and joins

2007-11-23 Thread Richard Broersma Jr
=-- On Fri, 11/23/07, Tom Hart <[EMAIL PROTECTED]> wrote: > The problem I'm having is that anything defined as a "text" datatype in > > postgres gets converted to a "memo" datatype in access, and when we > attempt to perform a join query on thatfield access starts complaining > > about not bein

Re: [GENERAL] ODBC, access, and joins

2007-11-23 Thread Martijn van Oosterhout
On Fri, Nov 23, 2007 at 03:48:01PM -0500, Tom Hart wrote: > The problem I'm having is that anything defined as a > "text" datatype in postgres gets converted to a "memo" datatype in > access, and when we attempt to perform a join query on that field access > starts complaining about not being ab

[GENERAL] ODBC, access, and joins

2007-11-23 Thread Tom Hart
Hi again everybody. I've got kind of a weird one today (the more complicated my db gets, the stranger the questions). I've built a data mine backend to replace our access data mine (eww, I know), but we'd like to still be able to use access to get to the tables, and write queries/reports/etc. a