Okay . . langsung saja saya jawab:
'Untuk menghapus ISI/RECORD tabel pada database lain:
DoCmd.RunSQL "DELETE namaTabel.* FROM namaTabel IN C:\namaDirektori\namaFile.mdb"
'-----------------------------------
'Untuk menghapus (menghilangkan) tabel dari database lain:
'Cara 1
Dim otdb As New Access.Application
With otdb
.OpenCurrentDatabase "C:\namaDirektori\namaFile.mdb"
.DoCmdDeleteObject acTable, "namaTabel"
.CloseCurrentDatabase
End With
'-----------------------------------
'Cara 2
Dim otdb As DAO.Database
Set otdb = OpenDatabase("C:\namaDirektori\namaFile.mdb")
otdb.TableDefs.Delete "namaTabel"
otdb.Close
Set otdb = Nothing
'-----------------------------------
Silahkan pilih VBA script mana yang sesuai dengan kebutuhan. Selamat mencoba . . . Have a nice day :-)
www.AstroDigi.com (Nino Guevara Ruwano)
true religion outlet, mulberry, lacoste pas cher, true religion jeans, nike air max, new balance pas cher, abercrombie and fitch, lululemon, hermes, nike blazer, longchamp pas cher, air force, vans pas cher, michael kors, nike free run uk, north face, sac guess, nike air max, air jordan pas cher, burberry, converse pas cher, north face, louboutin pas cher, nike air max, nike free, vanessa bruno, ralph lauren pas cher, sac longchamp, michael kors, ralph lauren uk, ray ban uk, air max, hollister, oakley pas cher, michael kors, hogan, tn pas cher, hollister pas cher, ray ban pas cher, nike roshe run, true religion jeans, timberland