CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2012
    Posts
    20

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

  2. #2
    Join Date
    Dec 2012
    Posts
    20

    Re: table does not exist error with ms access

    n yes....the error is ORA-00942!! how to solve it?

  3. #3
    Join Date
    Dec 2012
    Posts
    20

    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
  •  





Click Here to Expand Forum to Full Width

Featured