Jet DB Engine disk or network error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Jet DB Engine disk or network error

Author

Topic

-Dman100-
Posting Yak Master

210 Posts

Posted - 2004-04-06 : 02:04:34

I'm getting the following error when submitting a form to an access DB.

Disk or network error
Microsoft JET Database Engine (0x80004005)

I'm running IIS 5.0 and have the virtual directory setup over a network share. I can access all of the other pages, but just get the above error when submitting the form.

I read some information about the problem being caused by a system environment variable. I found the following Microsoft article on the error mentioned above:

http://support.microsoft.com/defaul...kb;EN-US;251254

I don’t quite understand the resolution. Can anyone elaborate and help me with this problem. Any help is appreciated. Thanks.
-Dman100-

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-04-06 : 14:31:26

The correct link for others to see: http://support.microsoft.com/default.aspx?scid=kb;en-us;251254

This is telling you that you need to define a System Environment Variable named TMP or TEMP and point it to a real folder on the system, and that the anonymous web user (IUSR_machinename by default) has permissions to the folder. In Windows 2000/XP go to the Start Menu, Settings, Control Panel, System. Clicke the Advanced tab and click the Environment Variables button. Define the variable in the System Variables section.

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]

-Dman100-
Posting Yak Master

210 Posts

Posted - 2004-04-06 : 15:40:48

Thanks for replying to my post. I am probably missing something simple, but I'm still having the same problem.

I have the following system variables defined:
TEMP C:\WINNT\TEMP
TMP C:\WINNT\TEMP

For the c:\WINNT\TEMP folder, I added the IUSR_myservername account and set the appropriate permissions. It showed once the account was added as Internet Guest Account.

I tried to submit the form to the access DB and still recieved the same error.

Did I set the variables incorrectly? Or not correctly set the permissions properly?

Thanks again for your help.
-Dman100-

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources