HI there,
im running a website on my pc through IIS and when I attempt to write to a file I get th ebelow error :
Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/paydayloans/onlineform.asp, line 90


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
POST 350 bytes to /paydayloans/onlineform.asp

POST Data:
mode=process&strTitle=Select&strFirstName=stevemai l&strSurname=mason&strAddress=17a&strPostcode=tw2& strHomePhone=0208&strMobilePhone=078423&strFax=020 292&strEmail=ssmason@gmasil.com&strBank=noChoice&s . . .

Time:
09 January 2006, 19:30:23


More information:
Microsoft Support


If i run this on my online server, i get no problems. Could someone please shed somelight on what it is i am missing.

the code i am using is

 nameSQL = "insert into personal (title, first_name, surname, address, post_code, home_phone, mobile, fax, email_address) VALUES	('"&strTitle&"','"&strFirstName&"','"&strSurname&"','"&strAddress&"','"&strPostcode&"','"&strHomephone&"','"&strMobile&"','"&strFax&"','"&streMail&"')" 
		  Set oRS = Conn.Execute(nameSQL)

cheers
steve

If Access, check the directory holding the database. Make sure your local IUSER account has read/write permissions.

If this is a SQL database then make sure the account you use to connect to the database has permissions.

Also, verify the insert statement works. Do a response.write nameSQL just before you execute the query. Copy the query and paste in Access or a Query Analyzer and see if it works.

possibly using the wrong cursortype http://www.devguru.com/technologies/ado/8651.asp

use adOpenDynamic which can be slow on Access or adOpenKeyset.