Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Using Access Instead of Visual Basic

    Hi Guys.

    I'm trying to copy a file in a folder using the Access module rather than VB. My Autoexec marco will run a Function fStart() that has the following code:

    FileCopy "E:\first.txt", "E:\first_bk.txt"
    DoCmd.Quit

    I do not have any problem if I double click the autoexec macro in access, the system will copy the appropriate file and quit the application. But I need to schedule this program to run at early hour. Whenever I double click the MDB file, the system copy the appropriate file but with popup window with the error message appear:

    Cannot find the file 'E:\db1.mdb' (or one of its components). Make sure the path and filename are
    correct and that all required libraries are available.

    What could be the problem? Thanks.
    :?:

  2. #2
    BrooksR is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2018
    Posts
    12
    Sounds like the problem is how things are setup in the scheduler. Are you using the Windows scheduler?

    Might be helpful to post a screen shot of what it looks like in the scheduler.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    instead of a drive letter, try using the unc for the path to db1.mdb so like //file/apps/db1.mdb or whatever E: is.

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

Similar Threads

  1. Basic Question
    By chris11590 in forum Forms
    Replies: 0
    Last Post: 08-04-2008, 05:57 AM
  2. Problem when activate the Visual Basic Editor
    By milo in forum Programming
    Replies: 0
    Last Post: 05-21-2007, 09:05 AM
  3. Rookie needs help with basic reporting
    By James Rousselle in forum Reports
    Replies: 0
    Last Post: 03-01-2007, 02:36 PM
  4. Visual Basic ToolBar and ImageList
    By Athanasopolous in forum Programming
    Replies: 0
    Last Post: 01-17-2006, 03:45 PM
  5. Basic Quoting System
    By Travstar in forum Access
    Replies: 2
    Last Post: 12-12-2005, 09:00 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