parthzad
Sep 6, 2005, 08:33 AM
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
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