locked
connecting to access db with visual basic RRS feed

  • Question

  • User360057345 posted

    Dim objConn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;" & "Data Source=C:\\popsCatering\\popsCatering.db")

            Dim objCmd As New OleDb.OleDbCommand("INSERT INTO personalInfo (Name) VALUES ('test')", objConn)

            objConn.Open()

            Dim objRdr As OleDb.OleDbDataReader = objCmd.ExecuteReader()

            objRdr.Close()

            objConn.Close()

     

    when i try to debug i get this error:

    OleDbException was unhandled

    Could not find file 'C:\popsCatering\popsCatering.db'.


    however i'm confident that the file exists and that the path is correct

    Wednesday, January 27, 2010 10:02 AM

Answers