coba pelajari sql pass through.
saya beri contoh, misalnya saya punya store procedure di sql server:
create proc sp_ListCustomer
as
select * from m_Customer
return(0)
cara manggil di access dengan buat query sql passthrough yang isinya:
exec sp_ListCustomer
jangan lupa property query ODBC Connect Str diset tembak ke ODBC SQL Server
yang dituju.
On Tue, Jul 1, 2008 at 3:47 PM, Ivan Leonardo <[EMAIL PROTECTED]> wrote:
> ada beberapa pertanyaan nih,
> 1. Stored procedures itu dibuat dan disimpan di sql server ? lalu kalau
> mau dipakai hrs kita panggil melalui VBA ?
> 2. Running query di server dan kirim hasilnya saja ?
> 3. bagaimana cara panggil/penggunaan stored procedure ?
>
> Thanks
>
> ----------------------------------------------------------
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and delete
> this e-mail from your system. E-mail transmission cannot be guaranteed to be
> secure or error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message, which arise as a result of e-mail transmission. If
> verification is required please request a hard-copy version.
>
>
>
--
Aksan Kurdin
