Code problem with moving db

have it in a temp folder, now not working

[Blelisa]

I am loading up a site for my boss to look through, I want to put it in my templates folder so they can surf it just like they would if it was loaded in the www page. The problem I am having is with my asp pages interaction with my database. I put my database in a folder called test in my templates folder (/templates/test/db)Now when I run the query I get this back:
Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/templates/insertit.asp, line 22

I checked the folder and it is rw-rw-rw.
If I load this page is the www folder and adjust the map path it works excellent. Does anyone know what could be wrong? Here is my code:
<%
set connection=Server.CreateObject("ADODB.Connection")
connection.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_
server.MapPath("/templates/test/developers.mdb")
connection.Open

sql="INSERT INTO [Bug] ([Tnum], [DateEntered], [BugDescription], [SimulatorsAffected], [SimulatorVersion], [Project], [EnteredBy], [FoundandReportedBy], [Priority], [Stat], [CorrectedDate], [CorrectedNotes])"
sql=sql & "VALUES"
sql=sql & "('" & Request.Form("number") & "',"
sql=sql & "'" & Request.Form("date") & "',"
sql=sql & "'" & Request.Form("desc") & "',"
sql=sql & "'" & Request.Form("simaff") & "',"
sql=sql & "'" & Request.Form("simver") & "',"
sql=sql & "'" & Request.Form("project") & "',"
sql=sql & "'" & Request.Form("entered") & "',"
sql=sql & "'" & Request.Form("found") & "',"
sql=sql & "'" & Request.Form("priority") & "',"
sql=sql & "'" & Request.Form("status") & "',"
sql=sql & "'" & Request.Form("datecorr") & "',"
sql=sql & "'" & Request.Form("corrected") & "')"

connection.Execute(sql)

[Easy_Coder]

It sounds like a permission issue are you sure that the permissions are set the way you had them set on your test server?

BTW, passing raw unchecked values off to the database is not a good idea. You should validate that stuff to keep your app out of trouble.

[Blelisa]

Thanks! I will validate!