Linking to an Oracle view from Access 97

[tigersbh]

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

 

[tigersbh]

Everyone,

If anyone thinks they know the answer, please post it. But don't work too hard, I have a workaround. I am just going to delete/rebuild that particular link in my code. That seems to work fine.

Thanks.