[aubreymh]

I have an Access table with an autonumber field and three additional fields. I am developing an online application to insert into the table. The following Insert statement works fine in my offline database:
INSERT INTO CLASS_REG_Fall08 ( MAIN_ID, CLASS_ID, DATE_REGISTERED ) VALUES (1496, 7, 20080820);

However, when I attempt do use the same syntax online (vbscript asp program), I get the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

It obviously is an updatable query, since the same syntax (omitting the autonumber field) works in Access on my PC. I am at a loss. Any ideas?

[Chicon]

Hi aubreymh,

Welcome to TSG !

You'll find some explanations on this page : How do I solve 'Operation must use an updateable query' errors ?.

[aubreymh]

Thanks. I have tech support for our server working on it "as we speak".