Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access Question
Message
De
17/11/2000 15:35:19
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
VBScript
Titre:
Access Question
Divers
Thread ID:
00443232
Message ID:
00443232
Vues:
48
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!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform