Please Help! I am trying to write to an Access database through a web application built in Ultradev. I can read the database no problem but when i try to write to it it returns with an error. The server is IIS on WIN2000 can anyone help?

Hi mike,

it sounds like a security issue, make sure the folder where the database resides, has 'write' rights allocated to the correct user account used in IIS.



Digga

Sharing Knowledge Saves Valuable Time!!!

Thanx for your reply. I have set the directory rights to FULL and it is still returning the same message..see below. It has nothing to do with field names as the are only three and a button.

txtTitle
txtDate
txtDetail
butSubmit

-----------------------------
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/abs/_admin/AddNews.asp, line 116
---------------------------------------

Hi Mike,

don't know if this helps

search.atomz.com/search/?sp-k=&sp-p=any&sp-a=sp1001395b&sp-q=0x80040E14&Search.x=25&Search.y=12

Digga

Sharing Knowledge Saves Valuable Time!!!