Hi, Thanks in advance for any ad

[new2unix]

Hi,

Thanks in advance for any advice on the following browser error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/chp2/chp5/insert_record.asp, line 6

========================================
The ASP syntax is as followed:

<%
Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )
Con.Open &quot;accessDSN&quot;

sqlString = &quot;INSERT INTO Products ( product_name, product_price ) VALUES ( 'Gift Basket', 34.54 )&quot;
Con.Execute sqlString
Con.Close
%>
========================================

 

[DRowland]

You need to contact your Internet Service Provider (ISP) and tell them to change your database to an updateable status. You can not make the change yourself, your ISP has to do it. I had the same problem.
By the way, for security, you might want to discuss the possibility of moving your database to another physical location, rather than on your website, itself. It makes it a lot harder for a hacker to get into your database, if it's located somewhere else. a few simple adjustments on your database location info, on your webpages, is all it takes to add this measure of safety to your data.

Hope that helped.

 

[shaddow]

U are trying to insert a string in Acess but is not correct
U have to use &quot; istead of '(this is for SQL statments) but in vbscript is a problem u have to put &quot;&quot; if u want to add in a string one &quot;
<%
Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )
Con.Open &quot;accessDSN&quot;

sqlString = &quot;INSERT INTO Products ( product_name, product_price ) VALUES (&quot;&quot;Gift Basket&quot;&quot;, 34.54 )&quot;
Con.Execute sqlString
Con.Close
%>

Hope this it helps
George

 

[dianal]

Hello,
Did some of the above responses solev the problem?
If not - one more sugegstion - use Recordset object in order to insert new rows.
D.

 

[new2unix]

Hi,

Thanks for the response. It was the security issue and I changed the permission for the directoty to &quot;READ/WRITE&quot;. After that, the insert worked but then I started to get different error if I tried to reload the page to fast. I posed the error in a separate message with subject: &quot;Provider error&quot;... Hopefully, I can get some input. Thanks again.

Mike