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;"
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???