-
January 7th, 2013, 02:36 AM
#1
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???
-
January 7th, 2013, 02:39 AM
#2
Re: table does not exist error with ms access
n yes....the error is ORA-00942!! how to solve it?
-
January 7th, 2013, 03:55 AM
#3
Re: table does not exist error with ms access
okz....i got the solution......
i kept the connection instances same for oracle and access.....thanks for viewing my problem.....solved
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|