There is a problem while testing database online. Actually, i have forms connected with access database and it's working fine on local system but when i upload the project and test it gives me problem in add new syntax "rs.addnew" but this syntax is working fine in my local system Does anyone knows how can i fix this problem: here is the error blow: Add: Microsoft JET Database Engine error '80040e09' Cannot update. Database or object is read-only. /admin/new.asp, line 36 Del: Microsoft JET Database Engine error '80004005' Could not delete from specified tables. /admin/list.asp, line 40
This is a permission issue. Your database is protected so script doesn't have permission to modify or delete the DB entries. You can use Select only.. Please set proper permissions through Admin Panel(cPanel)
most of the chances, your access db should be in a special folder defined by the system. usually, the directory the db should be in resides outside the main site directory so people cant download it. check your host for such limitations. another thing it might be, is permissions are automaticly set to read only on upload, try chmod for the file to 777. gl.
Thanks for favor actually, i don't know how can i set permissions? would you like to favor me in this meter too?
Actually i view and access database only and when i login from admin pannel throgh login page it's working fine but there is a problem only in "rs.addnew" command and in delete section....... i don't know why it happens...... do you have any idea how do i set permission on it?
you can change permissions on your servers cpanel>>filemanager what you are looking for is the chmod command.