When you try to access JET data source like MS Access or MS Excel from your Active Server Pages (ASP), you may get this problem
Microsoft JET Database Engine error '80004005'
Unspecified error
You have set the permission of your IUSR_ComputerName user to full control, may be you already give full control permission to everyone, but the problem still occur.
You also reinstalled your JET with latest service pack, rebooted the server, but the problem still exists.
The problem actually is you have set the environment variables TMP and TEMP to invalid temporary folder.
Please access the Microsoft Knowledge base for more details:-
PRB: "Disk or Network Error" or "Unspecified Error" Returned when Using Jet
http://support.microsoft.com/kb/251254
After set the environment variables correctly, please remember to restart your computer. If it still can not work, you may need to change the temporary folder or set the temporary folder have EVERYONE full control.
Good luck!
6 comments:
Great !! Thanks for the help. This did solve my problem.
Thanks,
KN
You were right on.
After days of detective work and trying solutions found elsewhere on the Web, I came upon your suggestion of checking the Temp environment variable.
I added the IUSR_ComputerName to the \TEMP folder and the Access database opened.
Thanks.
GW
Genial, simplemente genial. Muchas gracias. Funcionó perfecto, nunca lo hubiera adivinado.
Thanks!It's really working.
thanks a lot
its working well
Thank you very much. It is working...
Post a Comment