Microsoft JET Database Engine error '80040e09'

[phuc2583]

I have a problem with an application I developed with code charge. Whenever I
try to access a table in a database I get the following error:

Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.

Secondly, I find it difficult to use code charge to append/add records from
one table(in a grid form) to another(within the same database)

Please, If you've come across this problem & have been able to solve it let
me know.
Regards
Hoang Phuc

[Merlin1857]

Hi,


You need to make the folder in which your database is stored a writable folder. Access it, right click it and go to the properties option, then access the 'Security' tab access the anonymous users listed (usually the last in the list) and in the Permissions fo USers window below allow Write permissions.

Good Luck

[CroCrew]

Hello phuc2583,

The problem does not fall on the permissions of a folder. First, I am assuming that your database is an Access database. What you need to do is change the permissions on the “file” that is known to be your database on the server.

The common ASP environment is setup that every visitor to your website uses the local server user called “IUSR_******”. You can change that if you want or remove it altogether but, for this example I will just use the default user called “IUSR_”. Think of the “IUSR_” as everyone in the world that can see your web server.

On your web server there are permissions that can be set on folders and files. These permissions throttle who can read, create, edit, delete, and more to files and folders on the web server.

So what you need to do is find the physical location of your database on the web server (don’t open it) and right clicking on the file and change the permissions and give your “IUSR_” modify permissions and you will be set.

Giving the “IUSR_” user special permissions like full Control or modify on a folder is not a good thing to do. Restrict permissions and only give out what is needed is the best way to keep your server from the bad guys.

Good luck~