Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access Question
Message
From
17/11/2000 15:35:19
 
 
To
All
General information
Forum:
Visual Basic
Category:
VBScript
Title:
Access Question
Miscellaneous
Thread ID:
00443232
Message ID:
00443232
Views:
43
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!
Next
Reply
Map
View

Click here to load this message in the networking platform