Having problem with access...

[laugabeib]

well...im no computer genius but i'm building my own guestbook and i'm using access database... but i always get this message when i try to post the messages: "Operation must use an updateable query." and the sql sentence goes this way: mySQL = "INSERT INTO gestir ( Nafn, Emil, Heimasida, Skilabod ) VALUES('" & nafn & "', '" & emil & "', '" & heimasida & "', '" & skilabod & "')" and then i say "connection.execute(mySQL).

Is there anyone out there who could possibly understand this and help me :D

p.s. i'm new to this forum so please be nice to me :confused:

[Frank]

You'll need to make sure that the folder in which your database resides has write permissions. If you are not sure you can contact your host. Most hosts (not free ones) have a folder specifically permissioned for database usage. If you are running it on your own PC or locally and have access tot he server then you'll need to set write permissions on the folder that the database is in, or move the database to a folder with write permissions.

[laugabeib]

Well....i guess youre right :D I think i'll look into it and see what i can do to fix this... maybe i will have to use some other database to make this work...

but thank you...this did help... i never would have thought of that

[Vimal]

I got this problem of...Operation must be an Updateable Query too..or sometimes 'Unspecified error' when I run my application on an NT server through IIS and try to access it through a network.

I have set the write permissions and all this stuff accordingy, but I still get the same error messages.

However, when I run the same application on Windows 98 through PWS, it works out fine. My logic tells me it is a problem of permission, but still it doesnt work out when I have set them accordingly.

This certainly doesnt solve your problem Laugabeib, but at least shows you're not the only one out there stuck with this problem.

Cheers,
Vimal

[omnifice]

I had the same problem and this worked on my Win XP Pro system:

Add the IUSR_<COMPUTERNAME> to the directory permissions and give it the appropriate access (write, modify, etc.).

Hope that helps.