Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking to an Oracle view from Access 97

Status
Not open for further replies.

tigersbh

Programmer
Jul 24, 2007
24
US
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top