belum bisa mas muncul pesan: Run-time error 2147217865(80040e37): the microsoft jet database engine cannot find tha input table or query 'del_employee'. make sure it exists and that its name is spelled correctly btw saya pakai koneksi data source ODBC lewat "link table" trus klo mau masuk ke sql harus login "sa" dan pasdword kosong thx
--- On Wed, 8/26/09, HENDRA <[email protected]> wrote: From: HENDRA <[email protected]> Subject: RE: [belajar-access] Memanggil sp SQL server di ms acces To: [email protected] Date: Wednesday, August 26, 2009, 12:47 PM Coba ganti baris contoh saya dari : CMD.CommandText = "spSTOCK" Menjadi CMD.CommandText = “del_employee” Semoga membantu From: belajar-access@ yahoogroups. com [mailto:belajar- acc...@yahoogrou ps.com] On Behalf Of wah Yono Sent: Wednesday, August 26, 2009 5:42 PM To: belajar-access@ yahoogroups. com 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 <hendragunadi@ gmail.com> wrote: From: HENDRA <hendragunadi@ gmail.com> Subject: RE: [belajar-access] Memanggil sp SQL server di ms acces To: belajar-access@ yahoogroups. com 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
