My novipt.mdb database has a
table called 'PATIENT' and a
field called 'PTNO'
After I use asprunner on it and try to add/update I get the error:
Error number -2147467259
Error description [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
URL /scott/demonovi/PATIENT_edit.asp
SQL query insert into [PATIENT] (PTNO) values ('sadf')
If I open up access and paste in the line
insert into [PATIENT] (PTNO) values ('sadf')
into a query - it runs fine.
I'm getting similar errors with update and delete as well. Any ideas?
Scott