Hello,
I am having trouble refreshing the link to an Oracle view from Access 97. I refresh links to some Oracle tables successfully, but not the view - I just get a long wait and a generic "ODBC Error" message. I have included the relevant code below. (I have tried the refresh of the view with and without the "SourceTableName" parameter).
Thanks for any help you can give me. Here is the code:
Dim strCon As String
Dim tdf As DAO.TableDef
strCon = "ODBC;Driver={Oracle ODBC Driver};DBQ=" & gRossRM_Server & ";Server=" & gRossRM_Server & ";Uid=" & gRossRM_UID & ";Pwd=" & gRossRM_PWD & ";"
For Each tdf In db.TableDefs
If tdf.Name = "RossRM_GGC_V_ARTS_ROSS_ORDERS" Then 'the view
tdf.Connect = strCon & "SourceTableName=FIN_TEST.GGC_V_ARTS_ROSS_ORDERS"
tdf.RefreshLink
Else
tdf.Connect = strCon
tdf.RefreshLink
End If
Next tdf
I am having trouble refreshing the link to an Oracle view from Access 97. I refresh links to some Oracle tables successfully, but not the view - I just get a long wait and a generic "ODBC Error" message. I have included the relevant code below. (I have tried the refresh of the view with and without the "SourceTableName" parameter).
Thanks for any help you can give me. Here is the code:
Dim strCon As String
Dim tdf As DAO.TableDef
strCon = "ODBC;Driver={Oracle ODBC Driver};DBQ=" & gRossRM_Server & ";Server=" & gRossRM_Server & ";Uid=" & gRossRM_UID & ";Pwd=" & gRossRM_PWD & ";"
For Each tdf In db.TableDefs
If tdf.Name = "RossRM_GGC_V_ARTS_ROSS_ORDERS" Then 'the view
tdf.Connect = strCon & "SourceTableName=FIN_TEST.GGC_V_ARTS_ROSS_ORDERS"
tdf.RefreshLink
Else
tdf.Connect = strCon
tdf.RefreshLink
End If
Next tdf