Dilruba
-
Total Posts
:
5
- Scores: 0
-
Reward points
:
0
- Joined: 11/12/2007
-
Status: offline
|
Ms Acce
Monday, November 12, 2007 11:32 PM
( permalink)
asp, vbscript, Ms Access I have used the following codes: connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\progam files\mail.mdb"
If (CStr(Request("MM_insert")) = "regorg") Then
ConnectionDb = connectionString
' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = sql
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
<message edited by Dilruba on Wednesday, November 14, 2007 5:49 PM>
|
|
|
|
ehvbs
-
Total Posts
:
3320
- Scores: 110
-
Reward points
:
0
- Joined: 6/22/2005
- Location: Germany
-
Status: offline
|
RE: update & insert operation, asp, vbscript, Ms Acce
Tuesday, November 13, 2007 2:48 AM
( permalink)
Hi Dilruba, do you get an error message? did you test the update sql statement from access? Regards ehvbs
|
|
|
|