Re: Error when accessing tables with deleted columns

I just wanted people to know if you have deleted a
column in postgres and can not relink the tables in MS
Access, the current solution is to
dump the database and reload it.

I was using 7.2.5 version of the odbc driver and
tested the CVS that Dave kindly arranged for me. If
someone would like me to test a later CVS please just
email me with the location of a compiled version and I
will attempt to recreate my problem.

Thanks for everyones help,
Michael

--- Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:
>
>
> > -----Original Message-----
> > From: Michael Calabrese
> [mailto:m2calabr(at)yahoo(dot)com]
> > Sent: 29 January 2003 22:20
> > To: pgsql-odbc(at)postgresql(dot)org
> > Subject: Re: [ODBC] Error when accessing tables
> with deleted columns
> >
> >
> > Thank you for the fast responce WOW. I could not
> ask
> > for better.
>
> You're welcome.
>
> > Now I am getting the error:
> > Runtime error 3409
> > Invalid Field definition 'UNKNOWN' in definition
> of
> > index or relationship.
>
> I don't really know Access, but don't you have to
> re-link the table so
> Access re-examines it's structure?
>
> Regards, Dave.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com