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

    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.

    Thanks


    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
    
                     .AddNew
    
                        If LTrim(RTrim(End_Time.Text)) <> "" Then
                            .Fields("Logout Time") = End_Time.Text
                        End If
                        
                
                     .Update
    
                    End With
    
                    r = r + 1
    
                    rs.Close
                                    
            Set rs = Nothing
            cn.Close
            Set cn = Nothing
            
            Else
            
            If vbNo Then
            
            End If
            End If
    
    End Sub

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    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
    Code:
        '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
    Posts
    2
    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
    Posts
    5,442
    Provided Answers: 14
    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
  •