Re: Error when accessing tables with deleted columns

> -----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.

Yes, that is where the error is comming from (linking
the tables). I still believe that it has something to
do with the deleted column. 1) It is still stopping
on the same table. 2) I have a close backup that does
not have the delete column and it works fine.

I can most likely make it work by dumping the DB and
reloading it. It is just that the one with the
dropped column is my production database. (sigh)

Thanks again for all of your 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

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