Coba ganti baris contoh saya dari : CMD.CommandText = "spSTOCK"
Menjadi CMD.CommandText = "del_employee" Semoga membantu From: [email protected] [mailto:[email protected]] On Behalf Of wah Yono Sent: Wednesday, August 26, 2009 5:42 PM To: [email protected] Subject: RE: [belajar-access] Memanggil sp SQL server di ms acces mas saya coba kok belum bisa y? Nama sp nya = del_employee kira2 apa yang salah y? thx yono --- On Tue, 8/25/09, HENDRA <[email protected]> wrote: From: HENDRA <[email protected]> Subject: RE: [belajar-access] Memanggil sp SQL server di ms acces To: [email protected] Date: Tuesday, August 25, 2009, 10:34 AM Ok. Saya sudah coba dengan kode demikian sudah bisa untuk mengeksekusi sp dan mengisinya ke recordset Dim CMD As New ADODB.Command Dim RST As New ADODB.Recordset Dim KODE As String CMD.CommandText = "spSTOCK" CMD.CommandType = adCmdStoredProc CMD.ActiveConnectio n = CurrentProject. Connection Set RST = New ADODB.Recordset RST.Open CMD.Execute Set CMD = Nothing Set RST = Nothing Semoga membantu From: belajar-access@ yahoogroups. com [mailto:belajar- acc...@yahoogrou ps.com] On Behalf Of wah Yono Sent: Tuesday, August 25, 2009 5:01 PM To: belajar-access@ yahoogroups. com Subject: [belajar-access] Memanggil sp SQL server di ms acces Saya coba membuat stored prosedure di ms SQL server untuk update table. kode sudah jalan klo di sql server cuma saya masih bingung kalau memanggilnya memakai ms acces tolong tuliskan kodenya thx, salam wahyono
