ASP Error
-
I have a problem with asp page, i have this statement: " con.execute("insert into members ( first_name, last_name, mobile, email, username, password) values('"&firstname&"','"&lastname&"','"&mobile&"','"&email&"','"&username&"','"&password&"')")" and i use access database when i run this page i have an error that told me to make "updatetable query" and i don't know how to do this could any one help me please
-
I have a problem with asp page, i have this statement: " con.execute("insert into members ( first_name, last_name, mobile, email, username, password) values('"&firstname&"','"&lastname&"','"&mobile&"','"&email&"','"&username&"','"&password&"')")" and i use access database when i run this page i have an error that told me to make "updatetable query" and i don't know how to do this could any one help me please
Check the permissions on the access .mdb file. If the iusr_machine account does not have write/modify access on the database, you cannot perform any updates. Also, because you have to modify these permissions, if possible move the access database outside of your IIS root folders.
-
I have a problem with asp page, i have this statement: " con.execute("insert into members ( first_name, last_name, mobile, email, username, password) values('"&firstname&"','"&lastname&"','"&mobile&"','"&email&"','"&username&"','"&password&"')")" and i use access database when i run this page i have an error that told me to make "updatetable query" and i don't know how to do this could any one help me please
1-Check your access database file .You must write,update permissions on it. 2-Try to open open database in write,update mode by code. '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 --junior coder--