I have a website installed on a server running on Windows Server 2003, i created a Data folder in the website main folder and put in there 3 access databases, set all the permissions and everything and they've been working fine until this morning when out of the blue when i try to write / update data in one of the dbs it returns the following error: "Microsoft JET Database Engine error '80040e09' Cannot update. Database or object is read-only.". It's not a problem with the Data folder permissions cause the write operation on the other two dbs works perfectly, i have tried to grab the malfunctioning db and put it on my local testing server and it works perfectly, i deleted it from the remote server and uploaded it again and it doesn't work. I noticed the attributes it opens on remote are DbConn.Mode = 1 while the other dbs it's 16, and Jet OLEDBatabase Locking Mode=0 while the for the others it's 1. Can anyone help me please?
DbConn.Mode = 1 Indicates read-only permissions. DbConn.Mode = 16 Allows others to open a connection with any permissions.