I am having trouble refreshing the link to an Oracle view from Access 97. I refresh the links to the 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 and get the same error).
Thanks for any help you can give me. The code is below:
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_ORDE RS"
tdf.Connect = strCon