The following code:

SQL = "UPDATE Members "
        + "SET Nursery = 1 "
        + "WHERE ID = "
        + NonVolunteerMember;

adoConnection.Execute(SQL);

gives the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/Scheduling/AddVolunteerToListSQL.asp, line 51


What does this mean? I have previously used this identical code and it worked. I am in the process of moving files around and this error has cropped up. Does it have anything to do with the way the table field is set up within access (2000). The data type is Yes/NO and the format field is blank.

Thanks,
Rich

__________________
Ego is a faithful friend; He stays with us all the way to the crater.

This was a server problem...not a code problem

Hi,

You need to check if you have Write permissions to the database. With an Access database, you just need to add your username with Modify permissions on the file's ACL. With a SQL database, you need to make sure that your username is one of the db_owners for the DB.

Cheers!

Marlon Villarama
Support Team
Web Burner Hosting
[email protected]
www.webburner.com
877-535-2876