Hi Again,
I have a little bit more information on the problem. I think it is a
problem
with files in tem****ary not cleaning themselves out. Went to "tem****ary
internet files", while I was running the program and deleted some of the
previous queries and the program resumed working, but I am not sure how to
cure the problem from a programming point of view.
Any ideas? I am using VBA in Excel.
Thanks for your help.
David
"David" wrote:
> Hi Group,
>
> I am going a Query in Excel 2003, using IE7, in Windows XP. Things go
along
> just fine, up to a point. There are about 60 queries and they are
working
> fine up to a point, then I get a failure message is:
>
> Run-Time error 1004:
> The file could not be accessed. Try one of the following:
> *Make sure the specified folder exists.
> Etc.
>
> But nothing has changed and it has been ok for a large number of
Queries.
> Some times I will be ok if I do the ".Refresh BackgroundQuery:=False"
over,
> but more often than not it still fails. It is as if there is an
overflow.
> Possibly it is my ISP, which is ATT or a factor I do not know how to
check, a
> loss of Memory? Anyone have any ideas?
>
> Thank you for your time and efforts.
>
> David
|
