ASP page not updating database

I made an ASP login page that checks an Access Database and if the username and password have not been used before, the visitor's name, IP address, and time are all updated in the database for that particular username/password combination.



The problem is that the server I'm working on will allow the script to work, just as long as I take out the update portion of the code. I know that CFM files work on the server, but I don't know if the server is only configured to insert data into a database using a CFM page.



The following is the error I'm receiving:



Microsoft OLE DB Provider for ODBC Drivers error '80004005'



[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.



/samplelogin/employee_visit_information.asp, line 30



Any help on why I would be getting this error would be greatly appreciated. Thanks

Perhaps the Access database and the folder it is contained in does not have write permissions for the I_USR account?

I understand that, but I have tried to set the permissions when I use the FTP program and it shows full rights, 777 under the CHMOD/Properties tab. The only time I've seen settings like you are talking about is when I am working with files on my server at home.



Where would I change these settings and how would I go about doing this; all I have is a FTP login.

If you are using a webhost for the site, it may be that your database has to be put in a specific folder on the server that has the correct permissions.



It shouldn't be held in the wwwroot folder because of the potential security risk.



If you're using a webhost, you should check with them.