Re: [Programmer-VB] Re: Bagaimana code vb untuk rename nama table SQL Server (database access)

[Padu Arsana iW]

hehe...jaka sembung saya tadi    btw untuk merename nama tabel pada database access pake ini, pak     Public Sub Ubahlah()  Dim dbSS As Database    Dim strDbName As String  strDbName = "D:\BETC\BETC.mdb"    Set dbSS = OpenDatabase(strDbName)    dbSS.CreateTableDef  dbSS.TableDefs("Test").Name = "Test2"      dbSS.Close  Set dbSS = Nothing  End Sub     jangan lupa gunakan DAO 3.6 pada references  semoga membantu.     salam,     Padu Arsana iW  Purwedi Kurniawan <[EMAIL PROTECTED]> wrote:        nah itu dia, stored procedure itu adanya di SQL Server, ga ada di MSAccess :)     rgds  [poer]   On 9/20/06, Frangky <franklin.id@gmail.com> wrote:         Mas Purwedi, saat ini saya praktekkan code-code ini pada database MSAccess.  Mungkin pesan error tersebut karena database-nya bukan SQL. 
     ----- Original Message -----   From: Purwedi Kurniawan   To: Programmer-VB@yahoogroups.com     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 <franklin.id@gmail.com > wrote:   Saya pakai code dari Mas Paduajus juga, ngga bisa. (muncul pesan error: TheMicrosoft 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       
	

	
		Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business.

__._,_.___





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 
       
 
    
  




__,_._,___