Cannot Update Web-enabled Access database

[MSchreiber]

Using Frontpage2003 and Access2003, I've created ASP.Net pages (Submission
and Results forms). The Results form displays my Access data w/o a problem.
With the Submission form I get the not uncommon "The operation failed. If
this continues, please contact your server administrator." error. My data
is all defined as text--no numeric data. Most of the suggestions I've found
are geared towards ASP and not ASP.Net. I hope someone out there can make me
a happy camper. Thanks for your help.

 

[Stefan B Rusynko]

In IE Tools Internet Options Advanced turn off Show Friendly http errors to see more detail on the error

Then check your update statement code for syntax errors (or post a snippet of it)



| Using Frontpage2003 and Access2003, I've created ASP.Net pages (Submission
| and Results forms). The Results form displays my Access data w/o a problem.
| With the Submission form I get the not uncommon "The operation failed. If
| this continues, please contact your server administrator." error. My data
| is all defined as text--no numeric data. Most of the suggestions I've found
| are geared towards ASP and not ASP.Net. I hope someone out there can make me
| a happy camper. Thanks for your help.

 

[Kevin Spencer]

It is possible that the folder containing your Access database does not have
the proper permissions for updating the database. Access is a file-based
database, and therefore, it requires that the account under which your ASP
or ASP.Net application runs has permission to change files. You might want
to check with your hosting service.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[Kyle Peterson]

regarding error messages
http://www.powerasp.com/content/hintstips/common_sense.asp

regarding permissions
http://www.powerasp.com/content/new/windows_2003_server_and_permissions.asp

http://www.powerasp.com/content/new/windows_xp_pro_and_permissions.asp