Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   MS access error (https://www.askmehelpdesk.com/showthread.php?t=12461)

  • Sep 6, 2005, 08:33 AM
    parthzad
    MS access error
    Hi,
    I am required to run series of MS Access Queries in a sequence one after another. I want to do this automatically as each query takes like 2-3 minutes.
    So, I created a form and as soon as the form loads, each query is executed.

    When I try to run my query for like last 5 day data, everything is perfect. But if I try to do it for last 30 days of data, I get an error message saying

    " Can not find file "xxxxx .mdb" (or one of its components). Make sure path and file names are correct and all libraries are available"

    Does anyone one how can I fix it ?

    Parth
  • Sep 6, 2005, 10:48 AM
    ScottGem
    Quote:
    Originally Posted by parthzad
    Hi,
    I am required to run series of MS Access Queries in a sequence one after another. I want to do this automatically as each query takes like 2-3 minutes.
    So, I created a form and as soon as the form loads, each query is executed.

    When I try to run my query for like last 5 day data, everything is perfect. But if I try to do it for last 30 days of data, I get an error message saying

    " Can not find file "xxxxx .mdb" (or one of its components). Make sure path and file names are correct and all libraries are available"

    Does anyone one how can I fix it ?

    Parth
    What line of code is giving you the error?

    • All times are GMT -7. The time now is 01:52 AM.