Results 1 to 2 of 2
  1. #1
    Greg Sipe is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    1

    Run-time error '3024': could not find the file 'c:\users\*****\Documents\dbo.mdb

    I am trying to create the structure of a SQL Server database in MS Access. This function results in the following error... Run-time error '3024': could not find the file 'c:\users\*****\Documents\dbo.mdb.
    Can anyone help me?

    Public Function importExternal(strDSN As String) As Boolean

    Dim i As Integer
    Dim retval As Variant
    Dim ODBCdb As Database


    Dim strConnection As String
    Dim srcTable As String
    Dim locTable As String
    Dim tdf As TableDef

    strConnection = "ODBC;DSN=" & Trim(strDSN)
    Set ODBCdb = OpenDatabase("", False, False, strConnection)
    DoCmd.SetWarnings False

    For Each tdf In ODBCdb.TableDefs
    If tdf.Name Like "dbo.*" Then
    srcTable = tdf.Name
    locTable = "dbo_" & Mid(tdf.Name, 5)
    DoCmd.RunSQL "SELECT * INTO " & locTable & " FROM " & srcTable & " WHERE 2=1"
    i = i + 1
    retval = SysCmd(4, "Processing " & srcTable)
    End If
    Next
    MsgBox i & " tables imported"
    ODBCdb.Close
    End Function

  2. #2
    dccjr's Avatar
    dccjr is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Location
    Colorado Springs, CO
    Posts
    138
    I am having the same issue with a split Access database. Was wondering if you found a solution?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 06-08-2012, 07:52 AM
  2. Replies: 2
    Last Post: 11-14-2011, 09:16 AM
  3. How many users at the same time?
    By raffie77 in forum Access
    Replies: 1
    Last Post: 08-21-2011, 09:05 AM
  4. could not find file due split pasted file
    By alex_raju in forum Access
    Replies: 1
    Last Post: 07-18-2011, 11:27 AM
  5. Error 3024 At Start UP
    By Damonpc in forum Access
    Replies: 10
    Last Post: 11-26-2010, 07:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums