Start Updating database records

Updating database records

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hello, I am having this problem when i try to update an Access 2000 table ("Break Times") in ASP based on some input that the user entered in a previous page. here is my code: -------------------------------------------------------------------- Set Conn1 = server.

Open parameters just like in the code mentioned above I get the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

I have checked the write permission box, then tried running the site again, and it really worked. Is there anyway i can have that database stored in it's original location (C:\) while being able to write to it, because if otherwise, if i dont do it the way i mentioned above, it wont update, but it wont give me errors either!!

Thanks alot Peace/Actually, After i have wrote my huge topic, i went to do the last thing i totally forgot to do, which is check the permissions on the IIS configuration screen for my default web site.

Maybe someone made an error while entering data into the database. Or maybe you want to provide a way for your Web visitors to update their email addresses.