Postgres Pro
Downloads
Home   >   mailing lists

Errors attaching tables to access. - Mailing list pgsql-interfaces

From Tim Uckun
Subject Errors attaching tables to access.
Date
Msg-id 4.2.0.58.20000921122251.00a4aa00@mail.diligence.com
Whole thread Raw
In response to upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found  ("Chris Haas" <haasjc@hotmail.com>)
List pgsql-interfaces
Tree view 
I am having some trouble attaching tables from postgres 7.0.2 to access 97.

when I attemp to attach a table I sometimes get this error message. 
"Invalid field definition 'UNKNOWN' in definition of index or relation" 
this only happens on some tables including some system tables.

For some tables I can attach but when I attempt to open it  i get 'ODBC 
call Failed' and then all the data in the table whows up as #Name?

Any clues?

:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/   Americas Background 
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered 
the risks of a bad hire.

pgsql-interfaces by date:

Previous
From: "Chris Haas"
Date:
Subject: upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
Next
From: Doug Budny
Date:
Subject: RE: Replication between MS-Access and PostgreSQL