detox — Thu, 04 Apr 2002 14:10:47 +0000

only 27,300 ????

Wil — Tue, 02 Apr 2002 15:40:23 +0000

Don't you just love Microsoft?

http://www.google.com/search?q=ODBC+Drivers+error+80004005

Results 1 - 10 of about 27,300. Search took 0.14 seconds.

artsapimp — Tue, 02 Apr 2002 15:30:25 +0000

I'm kind of embarrassed to write this but we have given full access to everyone while testing this and it still didn't fix the problem. I have tried everything that I can find.

Yes, I also tried the microsoft support which did not resolve my problem. When searching microsoft for that error you get a large number of resolutions. I tried every one I could find.

My resolution to this point is to create a link to the excel document within access and reference it with the same connectstring as the rest of the data. It seems to be easier on the server anyway.

Does anyone know of a better way or a problem I might find down the road by using this method?

Peter J. Boettcher — Tue, 02 Apr 2002 13:41:37 +0000

What are the permissions on the file (file system)? Make sure the IUSR_machinename account has enough access to wherever that Excel file is.

Is the file password protected?

Wil — Tue, 02 Apr 2002 10:15:48 +0000

Does the following information help?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q190006