hi... i run my pages locally without any error, but after uploaded to web, it show me the error... how is this happen? any1 got any idea? pls help... it show me this kind of error...

Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

Source Error:


Line 145:
Line 146: Conn.Open ()
Line 147: ObjCmd.ExecuteNonQuery ()
Line 148:
Line 149: Conn.Close ()

im using a insert command for objCmd, i can insert it locally.... how come it cant insert on web.....

Best regards
Life's Ng

This is often caused by access permissions on the other machine. What is your data store? If it's Access, there might be a file permissions problem, if it's MS-SQL or some other DB server, you might not have the right user permissions on the table(s) you are trying to insert to.

Peter

hi, i click on the .mdb file, on the security tab, i add the ASPNET and IUSR, set both of their permission to full control...

for the db's folder, click on Security/Add, and do the same things... then upload it.... but it still cant work...

then i copy the db's folder and check the security, there is no ASPNET and IUSR.....

im using access.....

Where are you making these security changes? I'm only asking based on the language you used. "...and do the same things... then upload it.... " That sounds to me like you are changing the file and folder on your local machine and then uploading the file to the server. The problem is mostly on the server. When you upload a file, particularly if you are using FTP, it will take on the security settings of the parent folder. Unless you change those, you'll continue to have the problem.

Peter

Can you access your server to change the security settings?

yeah thanks!!! just got it work!