table does not exist error with ms access
Hello....:)
i connected my vb 6.0 program to ms access 2007 by the following:
**Public conn As New ADODB.Connection
Public Sub openConn()
conn.CursorLocation = adUseServer
conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\VB\FACIDS.accdb;"
End Sub**
then i try to retrieve data from this database in vb 6.0 using this:
**SSQL = "SELECT IPADDRESS, NEID FROM IPADDS WHERE FACID='" & FLGIS & "'"
If rec3.State = 1 Then rec3.Close
rec3.Open SSQL, conn, adOpenDynamic, adLockOptimistic
If Not rec3.EOF Then
While Not rec3.EOF
xlsheet4.Range("A" & rowct3).Value = rec3("IPADDRESS")
xlsheet4.Range("B" & rowct3).Value = rec3("NEID")**
Ipadds is the table within the database and flgis is a variable....
am getting the error that table or view does not exist while running this.....the same program is connected to an oracle database also...but no problem with it....can both databases be connected together??
any help plz???
Re: table does not exist error with ms access
n yes....the error is ORA-00942!! how to solve it?
Re: table does not exist error with ms access
okz....i got the solution......:D
i kept the connection instances same for oracle and access.....thanks for viewing my problem.....solved