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.
