Please help me with your article Posted: 16 Feb 2006
I use your asp files and database file in article "Inserting Form content into Database with ASP" created virtual directory in IIS and im using windowsxp and MSAcess 2002. While executing file on pressing submit button i got this error on page form_ac.asp " Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /newtest/form_ac.asp, line 32 " and data wasnt posted to mdb file. please help me with this asap. thanks
Re: Please help me with your article Posted: 27 Jun 2007
The Access database does not have WRITE permission for the IIS to update her. To correct that, go to Start->Control Panel->Administrative Tools->Internet Information Services. From the IIS window that pops up, keep on expanding the nodes in the websites tree on the left until you get in the folder that contains the Access database. Move the mouse over the Access database and then right-click, and select 'Properties'. Now from the window that pops up, select the 'File' tab, and from it, make sure that BOTH READ and WRITE are checked.