Pake ini kali yaa.. 

ALTER TABLE Employees ADD COLUMN Notes TEXT(25)

Saya dapet dari helpnya MS access.

Best regards,
Sandi
 
 
-------Original Message-------
 
From: Bodhi
Date: 11/26/2008 8:52:56 AM
To: [email protected]
Subject: [BinusNet] tanya alter table di access
 
halo temen2.. mo tanya nih, g kan punya database access, tadinya tipe-nya
text(10), trus g modif program, and di program baru ini, ternyata butuh text
yg lbh besar, so g update jadi text(15), kalo lokal sih gampang, 
masalah-nya program tsb dipake ditempat temen g yg jaraknya jauh, so, g
pengen modif table-nya, biar berubah jadi text (15).. so nanti g bikin
program kecil di vb yg isinya modifikasi tipe data itu.
 
yg pengen g tanya syntax-nya gimana ya, kalo di oracle g bisa pake alter
table, tapi di access gimana ya...
 
thx.
 
 
 
 
 
[Non-text portions of this message have been removed]
 
 
------------------------------------
 
"We cannot all do great things.But we can do small things
with great love." - Mother Teresa
---------------------------------------------------------
 
BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan
Moderator BinusNet : Suryadi Liawatimena & Surya Iskandar
 
Stop or Unsubscribe: send blank email to [EMAIL PROTECTED]
com
Questions or Suggestions, send e-mail to [EMAIL PROTECTED]
 
Yahoo! Groups Links
 
 
 

[Non-text portions of this message have been removed]

Kirim email ke