Ask Experts Questions for FREE Help !
Ask
    parthzad's Avatar
    parthzad Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Sep 6, 2005, 08:33 AM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Sep 6, 2005, 10:48 AM
    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?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Automation error in MS Access [ 0 Answers ]

Hi, Please Help I am working with an Access database that was developed using Office 97 and was converted to the 2002-2003 Access file format. On this one form there are 26 text boxes (representing yearly pay periods) and on the “On Lost Focus” event for each text box the person who...

MS Access Linkmaster Error [ 1 Answers ]

I have created a simple database of products. I need to be able to enter an order that would update an ordersdetail table. I created an order form with a subform for entering product order. (I referred to the Northwind database for help). Everything seems fine except that when I try to enter...

Access Denied Error [ 10 Answers ]

Problem: Can not access data on a Hard Drive which came from another (now discarded) PC. The HD won't boot by itself (has XP Pro installed which I think is corrupted ). I have the HD mounted as a 2nd HD in a new (XP Pro) computer. The HD is visible as D: and I can see all the directories, but...

Access Run Time Error [ 1 Answers ]

Runtime error '1004'. How can I have this fixed!

Access 2000 error [ 5 Answers ]

Hello to all. We are using an access database 2000 with 30 users. The dbase size is 50 Gig. For some reason we keep getting an error messsage that the dbase is not in recognized format and has to be repaired. This error can show up to 10 times a day. Please help. Thanks

View more questions Search