Results 1 to 4 of 4
  1. #1
    jfrench is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    1

    RunTime Error 3024 - access 2016 - mdb file not being created

    We are running access 2016 and getting a runtime error of 3024 when running the following code. This error has never occurred and we run this process every month and have done so for years. It appears to me that it is not creating the mdb file. I have validated that the code is returning to correct variables for sfilename, and sfilepath. Where would I check for access errors on the server. when I place a file in the directory and rename it to the mdb file that the copy section is looking for I get the same error. How would I check for permission issues in creating the mdb file? Thanks in advance for any input. I am a DBA not a developer. Regards,





    Click image for larger version. 

Name:	access debug error.PNG 
Views:	20 
Size:	67.3 KB 
ID:	29860Click image for larger version. 

Name:	access error 1.PNG 
Views:	20 
Size:	22.4 KB 
ID:	29861

    '************************************************* ************************************************** '
    ' STEP 3 - Create new archive database '
    '************************************************* ************************************************** '
    '#3 of 13
    ' Show progress bar meter
    ProgMeter2 (0)

    Dim sCopyShell As String

    ' Create a string with no / on date
    sFridayFileDate = txtLastMonthDayDate.Value

    ' Create the filename
    sFileName = "ME" & sFridayFileDate & ".mdb"
    'Path and filename for new mdb file
    sFilePathName = "\\cfbf-sql\MBDB\Archives\MONTHTLY_PROD" & txtFolderYear.Value & "" & sFileName
    ' sFilePathName = "\\test-sql\MBDB\Archives\MONTHTLY_PROD" & txtFolderYear.Value & "" & sFileName
    ' Get full copy path
    sCopyShell = "cmd /c copy \\cfbf-sql\ITDB\METEMPL.mdb \\cfbf-sql\MBDB\Archives\MONTHTLY_PROD" & txtFolderYear.Value & "" & sFileName & ""
    ' sCopyShell = "cmd /c copy \\test-sql\ITDB\METEMPL.mdb \\test-sql\MBDB\Archives\MONTHTLY_PROD" & txtFolderYear.Value & "" & sFileName & "
    ' Copy Weekly Archive Template to \\member2\MBDB\Archives\MONTHTLY_PROD\
    Shell sCopyShell

    ' wait till file is copied
    Sleep 5000

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I used to programmatically copy revised Access frontend to user computer C:\ root and then IT tightened up permissions and could no longer do that. Have your folder permission settings been changed to remove Write privilege? Maybe that would prevent saving a new table into existing db file.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    yeah is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Nov 2010
    Posts
    61
    Every get your problem fixed?

  4. #4
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Old thread I know - but Windows 10 made it much harder to do anything directly into c:\ root directory.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Replies: 2
    Last Post: 06-19-2016, 12:32 PM
  2. Replies: 1
    Last Post: 05-31-2016, 05:18 AM
  3. "Could not find file <file path." - Error 3024
    By jmitchelldueck in forum Access
    Replies: 4
    Last Post: 07-30-2015, 02:15 PM
  4. Replies: 1
    Last Post: 04-30-2013, 05:44 PM
  5. Replies: 0
    Last Post: 12-08-2011, 09:12 AM

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
  •  
Other Forums: Microsoft Office Forums