2. ASPRunnerPro General questions
  3. Can't add/delete/edit
This topic is locked

Can't add/delete/edit

 		3/3/2004 4:31:45 AM
ASPRunnerPro General questions
M
 mashacpa author

When I try to delete a record, I get the following message:
Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.

SQL query delete from [SIPP] where [PatientCode]=123456
When I try to add/edit record, I get the following:
Error number -2147467259

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

URL /SIPP_edit.asp

SQL query insert into [SIPP] ([PCode], [Title], [Address], [City], [State], [Zip], [Phone], [Email], [Insurance], [Aller], [CaseMan], [DOB], [CaseManPhNum], [Delivery], [Communication], [Fax], [PrivacyStand], [EnablerName], [EnablerCont], [CurrentP], UserName) values (777777, 'Ms.', '123', '', 'CA', 92612, '', '', '', '', '', NULL, '', '', '', '', '', '', '', 0, 'Admin')
I am using a table called Users in my database, where the user called Admin has all permissions, while others can only see the records they entered.
My database is located in the wwwroot/db directory.
Sergey, please help!!!
Masha Simonian
Sergey Kornilov admin 3/4/2004

Masha,
please check this thread for detailed info on setting permissions:

http://www.asprunner.com/forums/index.php?...p?showtopic=412
Feel free to contact me if you still having this problem.
M
 		mashacpa author 3/5/2004

I did not have IUSR user, so I added it, but it did not help. Does it matter that I have Windows XP Pro, and not Windows 2000/2003 Server? Does it matter that my computer is not the actual Internet server (I upload pages to my host)?
Thanks,
Masha
Sergey Kornilov admin 3/5/2004

Masha,
you don'thave to add IUSR_ user manually. Probably you just need to set full access rights on this directory for everyone.
When you test it on the Web server this a little bit different story. Most Web hosts have a designed folder for databases outside WWW root with required permissions. You will need to put your database file to that designated folder and adjust database path accordignly in connection string.
If nothing helps please contact me directly at support AT xlinesoft.com