database

[diana]

HY
I can't write in my acces database? i have a error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

I know something is wrong with my internet?

I don't know how can I make this?
IUSR privileges must be set to "read/write".
The permissions on the database itself does not have full read/write privileges in effect.


THGKS
DIANA

[diana]

In short. Go to the folder where the database resides with Windows Explorer, right click op de database, properties, security. Make sure the internet user has full control over this file.

I don't know what I must check here?
read & execute allow is check i don't know what I must do?
by acces is not read-only...

How can I do this
ths
diana

[diana]

Client=request.querystring("nom")

Titre=request.querystring("titre")
Representant=request.querystring("representant")
Datew=request.querystring("deve")
Adresse=request.querystring("adresse")
Heure_debut=request.querystring("debut")
Ville=request.querystring("ville")
Prix_a_la_porte=request.querystring("porte")
Code_postal=request.querystring("CP")
Prix_a_la_avance=request.querystring("avance")
Pay=request.querystring("pay")
Style_artist=request.querystring("style")
Telephone1=request.querystring("phone1")
Telephone2=request.querystring("phone2")
Adresse_email=request.querystring("aemail")
Website=request.querystring("web")



set objConn=server.Createobject("ADODB.Connection")
objConn.ConnectionTimeOut=60
objconn.open"DSN=Spectacle"


Titre=Trim(request.querystring("titre"))
If Titre ="" Then
response.redirect"formulaire.htm"
End If


Representant=Trim(request.querystring("representant"))
If Representant ="" Then
response.redirect"formulaire.htm"
End If

Datew=Trim(request.querystring("deve"))
If Datew ="" Then
response.redirect"formulaire.htm"
End If

Adresse=Trim(request.querystring("adresse"))
If Adresse ="" Then
response.redirect"formulaire.htm"
End If

Ville=Trim(request.querystring("ville"))
If Ville ="" Then
response.redirect"formulaire.htm"
End If

Code_postal=Trim(request.querystring("CP"))
If Code_postal ="" Then
response.redirect"formulaire.htm"
End If


Telephone1=Trim(request.querystring("phone1"))

If Telephone1="" Then
Telephone1="0"
End If

Telephone2=Trim(request.querystring("phone2"))

If Telephone2="" Then
Telephone2="0"
End If

Prix_a_la_porte=Trim(request.querystring("porte"))
If Prix_a_la_porte ="libre" Then
Prix_a_la_porte="0"
End If

Prix_a_la_avance=Trim(request.querystring("porte"))
If Prix_a_la_avance ="libre" Then
Prix_a_la_avance="0"
End If

Adresse_email=Trim(request.querystring("aemail"))
If Adresse_email ="" Then
Adresse_email=" "
End If

Website=Trim(request.querystring("web"))
If Website ="" Then
Website=" "
End If



qrysql="insert into Treservation(nom_artist,titre,rep,datespec,adresse,heure_debut,ville,prix_a_la_porte,code_postal,pri x_a_avance,pay,style,nr_phone1,nr_phone2,email,website) values ('" & Client & "','" & Titre & "','" & Representant & "','" & Datew & "','" & Adresse & "','" & Heure_debut & "','" & Ville & "','" & Prix_a_la_porte & "','" & Code_postal & "','" & Prix_a_la_avance & "','" & Pay & "','" & Style_artist & "','" & Telephone1 & "','" & Telephone2 & "','" & Adresse_email & "','" & Website & "');"
set objrec=objConn.execute(qrysql)


objconn.close
set objconn=nothing

response.redirect"carte.htm"
%>

[diana]

Originally posted by Dave Clark
Read and Execute is not enough. To issue an Insert, you've got to have Update or whatever allowed.

Dave

i want please a example!!!
thks diana

[diana]

Originally posted by Dave Clark
An example of what? You said this:

I was responding to that. You must know how to set at least the read & execute permissions. The update permissions would be in the same place -- wherever you found the read & execute permissions.

Do a screen shot of where you found those permissions and attach it to your next post.

Dave
i don't know you want this..permission?

[diana]

Originally posted by Dave Clark
Yes, that is what I wanted to see. Thanks.

So, you have all the permissions set, but I notice that you have "Allow inheritable permissions from parent to propagate to this object" also checked. Try unchecking that to see what happens.

Dave

I make this it doesn't work!!
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
diana

[diana]

Originally posted by Dave Clark
Well, I looked up your error code and message text on MSDN and this is what I came up with:

http://support.microsoft.com/support/kb/articles/Q174/6/40.asp

Basically, this says that you're trying to simultaneously update more than one table. Is Treservation the name of a table? ...or is it the name of a query?

Dave
Treservation is a name of table...

[diana]

Originally posted by Dave Clark
Or, if that doesn't solve it for you, here's a guy that solved it a different way:

http://forums.webdeveloper.com/showthread.php?s=&threadid=15072

Dave
I think I got it!!!my folder with the database don't have a permission for written...know it's ok,,,
THKS
diana