This topic is locked

Error number -2147467259

5/9/2003 2:33:38 PM
ASPRunnerPro General questions
author

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

admin 5/10/2003

Scott,
this problem with Web server access permissions. Anonymous user should have write access to the folder where your database file reside.
See this topic for more information:

http://www.asprunner.com/forums/index.php?...?act=ST&f=2&t=6
Sergey Kornilov

S
shasta247 5/15/2003

Admin,
On a FrontPage webserver the anonymous user (or any user with a password) must be a "contributor" and the web site/domain must be set to execute "scripts"
I'm all set now. I just thought I throw some info your way.
Thanks a ton!
Scott