Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Hello, I'm executing the following SQL against an Access database... UPDATE Items SET Name = 'Squeeky toy', FK_User = 12, Description = 'blue and white spider', Starting_Bid = 4, Bid_Increment = 1, Image_URL = 'http://localhost/bwe/jon.gif', Expires = '23/08/2002', Active = True WHERE Items.PK_ID=1 I can't see anything wrong with it myself and nor can Access when I try it directly in it's Querying tools. It did used to work but recently I've switched hosting companies and I'm just testing stuff now. I'm getting the above error message and I've not a clue what it is. I don't wat to contact their tech support before I've got an idea to what the problem is. Can anyone help please? Thanks, Nick --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
