Kbase P143791: Microsoft Access 2003 is unable to use Multi Database connectivity when connecting to multiple copi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/27/2009 |
|
Status: Unverified
SYMPTOM(s):
Microsoft Access 2003 is unable to use Multi Database connectivity when connecting to multiple copies of the same database. Getting Microsoft Access error Cannot define field more than once. (error 3191)
FACT(s) (Environment):
Connectivity with third party ODBC client software is successful utilizing catalog names to interact with multiple databases connected to with one datasource.
Microsoft Excel clearly distiguishes multiple databases when using the OpenEdge Multi-Database connectivity options within the ODBC datasource to link tables in Microsoft Excel.
Windows
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
When attempting a connection to multiple OpenEdge databases using the Multi-Database connectivity options for an ODBC datasource Microsoft Access will show multiple instances of the same table within its link database wizard. However, any attempt to select one of the duplicate tables (tables common to multiple databases) will generate Microsoft Access error 3191 "Cannot define field more than once."
This appears to be a limitation within Microsoft Access.
FIX:
Do not use the OpenEdge Multi Database connectivity options when defining datasources to be used within Microsoft Access.
Configure individual datasources to each of the required databases from which data is desired.