Re: Error when accessing tables with deleted columns

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