|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 25th, 2009, 03:01 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Updateable multi-table query with inked table to a Progres backend
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. 
|
|
#2
March 25th, 2009, 03:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Updateable multi-table query with inked table to a Progres backend
hi Pete,
Pete wrote: 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 --
|
|
#3
March 25th, 2009, 03:26 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Updateable multi-table query with inked table to a Progres bac
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" wrote: hi Pete, Pete wrote: 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 --
|
|
#4
March 25th, 2009, 04:44 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Updateable multi-table query with inked table to a Progres bac
hi Pete,
Pete wrote: 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 --
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
