Linked Tables failure; Access 2003

[David P. Lurie]

Access 2003
MSDE 2000 SP3a

PostgreSQL 7.3.4 on SCO OpenServer 5.0.7
psqlodbc 7.03.02.00 ODBC driver

Unify 6.0 on SCO OpenServer 5.0.7
old ODBC driver from Win NT era (still works)

Can create linked table or import data from table in a database on either
the Unify or PostgreSQL server from within an Access database.

Import works within an Access project, with similar steps as an Access
database, but linked table creation to either server fails, either with
linked server or Transact-SQL query options.

The connections can be created, but "This data source has no visible tables"
error occurs when the connection is used, even though a specific table was
specified when the connection was created.

Linking to a linked table to these servers previously created in an Access
database works, but is incredibly slow, as expected.

Thanks,

David P. Lurie

 

[David P. Lurie]

Found a probable answer in MSKB -

Microsoft Knowledge Base Article - 287414

http://support.microsoft.com/default.aspx?scid=kb;en-us;287414&Product=acc2003

 

[David P. Lurie]

Found a probable answer in MSKB -

Microsoft Knowledge Base Article - 287414

http://support.microsoft.com/default.aspx?scid=kb;en-us;287414&Product=acc2003

This describes the problem, but the solution only works for connection to an
Access database, not a non-MS ODBC source. I have used the same steps with
the MS OLE DB Provider for ODBC drivers without success, as described in my
initial post.

David P. Lurie