I have a code:
Dim wrkRemote As Workspace
Dim dbsRemote As Database
Dim strConnect As String
Dim rst As ADODB.Recordset
Dim db1 As Database
Dim rst2 As Recordset
Dim rname As String
strConnect = "ODBC;DSN=ORAPRD0;UID=******;DBQ=PRD0;ASY=OFF;PWD=****"
Set wrkRemote = DBEngine.Workspaces(0)
Set db1 = wrkRemote.OpenDatabase("", False, False, strConnect)
rname = "LAND_REP"
Set rst2 = db1.OpenRecordset(rname, dbOpenDynaset)
So the connection is open why can't I query tables? Do they need to be refreshed or something?
It complains that the table or query LAND_REP is not found. I am just trying to test the connection between oracle and Access. Because I have a whole Access app working except I need to put tables into Oracle. At the moment they are in mdb file but on Monday they will be moved into Oracle. Is it going to throw everything off? All my queries and interaction between forms and tables?
Dim wrkRemote As Workspace
Dim dbsRemote As Database
Dim strConnect As String
Dim rst As ADODB.Recordset
Dim db1 As Database
Dim rst2 As Recordset
Dim rname As String
strConnect = "ODBC;DSN=ORAPRD0;UID=******;DBQ=PRD0;ASY=OFF;PWD=****"
Set wrkRemote = DBEngine.Workspaces(0)
Set db1 = wrkRemote.OpenDatabase("", False, False, strConnect)
rname = "LAND_REP"
Set rst2 = db1.OpenRecordset(rname, dbOpenDynaset)
So the connection is open why can't I query tables? Do they need to be refreshed or something?
It complains that the table or query LAND_REP is not found. I am just trying to test the connection between oracle and Access. Because I have a whole Access app working except I need to put tables into Oracle. At the moment they are in mdb file but on Monday they will be moved into Oracle. Is it going to throw everything off? All my queries and interaction between forms and tables?