This topic is locked

Error number -2147467259

1/31/2004 9:25:20 PM
ASPRunnerPro General questions
C
cherrywine author

I get the following error when I try to add a record to the database:
Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

URL /mis/Output3/Products_edit.asp

SQL query insert into [Products] ([ItemNumber], [ItemType], [ItemProducer], [ItemDescription], [ItemTitle], [ItemPrice], [ItemQuantity], [ItemReserve], [User]) values (1, 'John', 'Test', 'Test2', 'Test3', 5.28, 4, 1, 'Jim')
The properties of the database and it's folder have permissions for read and write. All fields of the table were used and field names contain no spaces, "-", or any special characters. Could someone provide some light on this subject.

Sergey Kornilov admin 2/1/2004

Hi,
this is permissions issue. If you test it on your local box make sure IUSR_ user has full permissions on database file. If you test it on your Web server make sure database file placed to folder with full access for everyone.
Please see this FAQ article for more info:

http://www.xlinesoft.com/asprunner/faq.htm#updatable