Hello everyone!
I am trying to insert record into access database at WEB server.
Here is code i am using:
sql = "INSERT INTO Info (Field1,Field2) VALUES ("Value1","Vilue2")
strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\InetSrv\FrontPage\Data\Database1.mdb"
Dim objCommand
Set objCommand = Server.CreateObject ("ADODB.Command")
objCommand.ActiveConnection = strConnect
objCommand.CommandText = sql
objCommand.CommandType = 1
objCommand.Execute
It gives me an error: Operation must use an updateable query.
Please help me here, what can I do to fix it.
Nothing from MSDN suggestions has helped.
Thanks in advance.
XO4Y BCE 3HATb,YMETb,IMETb!