JET ERROR 80004005 During Update

[dave001]

I have an update page that contains a Live Object Update Form that appears to be set up ok (it shows all teh fields in the record and using Live Object nav Bars I can cycle throught eh records no problem. However, whenever I submit an update I get 'MS JET database Error 80004005 - Operation must use an updateable query'. I have tried every which way to avoid this but am now completely foxed. Any ideas please for wjhat should be a simple operation. The error is the same whether I use A2k or A97 tables and the db is not read only.

Thanks
Dave(UK)

 

[link9]

Check the permissions on the directory where the db resides -- make sure your script has WRITE permissions on that directory.

 

[dave001]

I must have write permisisons because in the FTP window I can open the db and change the data on the server side..

Could it be anything else..

Thanks

 

[link9]

here's an article on the subject:

http://coveryourasp.com/ADo4.asp

From what I'm reading, it's definitely a permissions issue.

You can also perform a keyword search on "Updateable Query" on this site, and come up with ALOT of discussion about the topic. It's a common problem.


Paul Prewett

 

[boyfromoz]

I get this error often when I ftp using cuteftp, but never when I use dreamweaver ftp.

I am unclear why