Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2013

    Question Unanswered: Run-Time error -2147467259 (80004005) Could not find file

    I'm trying to capture time in a Access form and store it row by row in a different Access' Table. I've tried this connection setup with excel and access and it worked fine. But Access to access it doesn't work.

    Also if someone could help me in projecting only the access form to the users would be much appreciated.


    HTML Code:
    Private Sub Logout_Click()
    End_Time.Value = Now()
    If MsgBox("No Changes will be allowed further! Are you sure you want to Logout?", vbYesNo) = vbYes Then
    Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
                    Set cn = New ADODB.Connection
                  [COLOR="Red"]  cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Z:\Attendance\Attendance.mdb"[/COLOR]
                    Set rs = New ADODB.Recordset
                    rs.Open "Attendance", cn, adOpenKeyset, adLockOptimistic, adCmdTable
                    r = 3
                    With rs
                        If LTrim(RTrim(End_Time.Text)) <> "" Then
                            .Fields("Logout Time") = End_Time.Text
                        End If
                    End With
                    r = r + 1
            Set rs = Nothing
            Set cn = Nothing
            If vbNo Then
            End If
            End If
    End Sub

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    does the file exist
    ie from the computer that is failing can you see that file on that path. normally I'd expect a URL such as:- //servername/servershare/path/to/file/fiename.ext

    Allen Browne (always an excellent source for Access 'stuff' suggests your methgod to openthe connection is wrong
        'Source: kb 198755.
        Dim cn As New ADODB.Connection
        Dim rs As New ADODB.Recordset
        cn.Provider = "Microsoft.Jet.OLEDB.4.0"
        cn.Open "Data Source=C:\Data\Northwind2003.mdb"
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2013
    Yes. The File exists.

    But the error keep on popping up even if I change the destination file to different locations.

    Could you please help?

    Mean while thanks I have changed the method to open the connection

  4. #4
    Join Date
    Mar 2009
    Provided Answers: 15
    Have a look at this: PRB: Error -2147467259 When You Try to Open the Same MDB File from Multiple Instances and see if it's related to your case.
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts