bing-bonger

Folks I have am designing an ASP based site in dreamweaver where the users can input data into a simple access database via a web form, i have done all the connections etc and they work fine, the data is displayed correctly etc...... however i have used the 'insert record insertion' function on dreamweaver, and when ever you enter the data into the form and hit submit it comes up with the error:-

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


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Madasafish; Hotbar 4.1.8.0)

Page:
POST 104 bytes to /pgm/add_jobs.asp

POST Data:
job_ref=csddc&job_title=czc&job_type=zxc&location= zxcz&contact=zcxz&description=czczxczxc&MM_insert= true


can someone please assist with what i am doing wrong?????

Michael Robinson

you need to use the UPDATE function mate if you are already bring back a query and updateing it.

bing-bonger

OK thanks for the replies or lack of....LOL

I've sorted it now, I was doing everything correct just didn't have the correct permisions set on the directory with the database on...

All is ok now


cheers folks