nah itu dia, stored procedure itu adanya di SQL Server, ga ada di MSAccess :)
 
rgds
[poer]
 
On 9/20/06, Frangky <[EMAIL PROTECTED]> wrote:
Mas Purwedi, saat ini saya praktekkan code-code ini pada database MSAccess.
Mungkin pesan error tersebut karena database-nya bukan SQL.
----- Original Message -----
Sent: Wednesday, September 20, 2006 12:41 PM
Subject: Re: [Programmer-VB] Re: Bagaimana code vb untuk rename nama table SQL Server

 
Microsoft Jet database engine???
databasenya pake sqlserver atau msaccess?

[wwn]
 
On 9/20/06, Frangky <[EMAIL PROTECTED] > wrote:
Saya pakai code dari Mas Paduajus juga, ngga bisa. (muncul pesan error: The
Microsoft Jet database engine cannot find the input table or query
'sp_rename'. Make Sure it exists and that its spelled correctly.

Private Sub Command1_Click()
   cnn.Execute "Exec sp_rename tbtransaksi,table10"
End Sub
__._,_.___

Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [EMAIL PROTECTED]

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer





SPONSORED LINKS
Indonesia phone card Programmer Indonesia tour
Indonesia travel Indonesia flower

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

Kirim email ke