make sure you have write permission on the .mdb file and that the correct user has these permissions
-----Original Message----- From: Nick Middleweek [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 augustus 2002 13:21 To: ActiveServerPages Subject: Problems with UPDATE ? 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] ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by the latest anti-virus software for the presence of computer viruses. www.motiv.nl ********************************************************************** --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
