Updateable multi-table query with inked table to a Progres backend

[Pete]

Re Access 2003

Is it possible to include a linked table from a Progress backend in an Acces
multi-table query, and have that linked table updatable?

Many thanks.

 

[Stefan Hoffmann]

hi Pete,

Is it possible to include a linked table from a Progress backend in an Acces
multi-table query, and have that linked table updatable?

Yes, but you need an appropriate ODBC driver.


mfG
--> stefan <--

 

[Pete]

Many thanks for the reply Stefan.

What do I need to determine to know which ODBC driver to use.

Also, would I use DAO, ADO, OLEDB, ODBCDirect etc?
Many thanks.

 

[Stefan Hoffmann]

hi Pete,

What do I need to determine to know which ODBC driver to use.

e.g.

http://uda.openlinksw.com/odbc/st/odbc-progress-st/

There exist afaik only commercial drivers.

See also:

http://www.connectionstrings.com/progress

Also, would I use DAO, ADO, OLEDB, ODBCDirect etc?

As it is a linked table, I would prefer DAO.


mfG
--> stefan <--