problem updating database

whenever i try to add a new entry to a database through ASP i keep getting the following message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

i have enabled WRITE in IIS and i have made sure that the database is not read-only in ODBC.

Funny thing is it was working fine a few weeks before but now when i try and add a new record that message keeps coming up.

I am fresh out of ideas. I have created a new DSN in ODBC but it still comes up with that message.

If anyone can help me it would be greatly appreciated

you might want to indicate SQL Connection (with the parameters)and Query information that you are using to help the description a bit.
What has changed since the code worked?
Did you alter any related (ssi maybe?) files in the meanwhile?

More than likely the IIS user account has no write permissions to the .mdb, possibly your host moved something or you did.

I have some info on this error here that may help

http://www.dougscode.com/forum4/topic.asp?TOPIC_ID=5

thanx doug. I have tried to change the security settings of the database but i have no Security tab when i right click on the database ? And i have looked for "Use Simple File Sharing (recommended)" setting in folder options like it said in that article but it can't be found. I am using Windows 2000 Server. I have also enabled write to the .mdb file in IIS but it still does not work.

In response OldJacques, there is no SQL statements in my coding.

How are you adding new data to the database without an SQL statement to define what values are being inserted into which fields of which table?

Normally there is an Insert statement which is used to handle this from ASP.

That is usually what should be the subject of the "[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query." error message.

What is the line of code causing that message then?

im using the ADO instead of SQL to insert records. The error is on the line where it says:

objRS.Update

And the lines leading up to it that supply the objRS.Update statement (like objRS.Openusually with parameters, objRS.AddNew, and objRS("fieldname") = value)?

guys thanx for all the input but it turns out to be just the permission settings of the .mdb file. Special thanx to Doug G for the article.