Monday, April 14, 2014

VBA untuk Menghapus Tabel Pada Database Lain

www.AstroDigi.comAstroDigi.com | Senin, 14 Apr 2014 | Setelah dimuatnya artikel terdahulu yang berjudul "VBA untuk Menghapus Tabel" (Sabtu, 12 Apr 2014). Saya menerima beberapa email yang menanyakan bagaimana bila tabel yang ingin dihapus berada pada database (file .mdb) yang lain?

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)

Comments :

8 comments to “VBA untuk Menghapus Tabel Pada Database Lain”

michael kors outlet
salomon running shoes
toms outlet
tory burch outlet online
golden state warriors jerseys
the north face uk
oakley sunglasses
beats headphones
tory burch outlet
air max 90
cartier watches
converse shoes
timberland shoes
snapback hats
michael kors outlet online
cheap wedding dresses
nhl jerseys
nike roshe
chicago bulls jersey
air jordan 13
baltimore ravens jerseys
fred perry sale
adidas outlet
asics running shoes
cartier bracelet
coach outlet
washington redskins jerseys
swarovski uk
lacoste outlet
air jordan 4
babyliss
new york jets jerseys
green bay packers jerseys
new york giants jerseys
cheap ray ban sunglasses
ray ban uk
bottega veneta outlet
calvin klein outlet
ray ban sunglasses uk
chanel outlet
cai2015627

Unknown said...
on 

ninest123 07.31
true religion jeans, oakley sunglasses, louboutin, michael kors outlet, michael kors outlet, coach outlet, longchamp outlet, tiffany jewelry, christian louboutin outlet, michael kors, kate spade outlet, prada handbags, ray ban sunglasses, gucci outlet, tiffany and co, replica watches, michael kors outlet, coach outlet, nike air max, polo ralph lauren outlet, louboutin shoes, ray ban sunglasses, tory burch outlet, michael kors outlet, jordan shoes, nike air max, oakley sunglasses, chanel handbags, coach purses, kate spade handbags, nike free, coach factory outlet, burberry, longchamp outlet, burberry outlet online, nike outlet, prada outlet, oakley sunglasses, polo ralph lauren outlet, longchamp, michael kors outlet, louboutin outlet

Unknown said...
on 

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

Unknown said...
on 

wedding dresses, soccer jerseys, nike roshe, abercrombie and fitch, iphone 6 cases, ferragamo shoes, reebok shoes, soccer shoes, ghd, asics running shoes, nike huarache, lululemon, vans shoes, instyler, nike roshe, oakley, insanity workout, p90x workout, mcm handbags, north face outlet, beats by dre, celine handbags, bottega veneta, baseball bats, north face outlet, longchamp, giuseppe zanotti, hollister, valentino shoes, new balance, nfl jerseys, hollister, jimmy choo shoes, babyliss, herve leger, mac cosmetics, birkin bag, timberland boots, chi flat iron, nike trainers, mont blanc, nike air max

Unknown said...
on 

swarovski, replica watches, toms shoes, ugg boots, supra shoes, marc jacobs, montre pas cher, links of london, thomas sabo, vans, hollister, ugg pas cher, ugg,ugg australia,ugg italia, nike air max, ray ban, ugg boots uk, ugg boots, ugg,uggs,uggs canada, karen millen, gucci, bottes ugg, lancel, uggs on sale, ralph lauren, hollister, converse, wedding dresses, pandora charms, louboutin, juicy couture outlet, converse outlet, juicy couture outlet, pandora charms, swarovski crystal, ugg boots, coach outlet, pandora jewelry, ugg boots
ninest123 07.31

Unknown said...
on 

air max 90
louboutin pas cher
iphone cases
ralph lauren uk
ferragamo shoes
fitflops outlet sale
adidas wings shoes
cheap nhl jerseys
ray-ban sunglasses
michael kors outlet
michael kors uk
gucci sunglasses uk
ralph lauren outlet
mulberry handbags
tory burch outlet online
michael kors handbags
michael kors outlet
michael kors outlet
cheap oakley sunglasses
ray-ban sunglasses
soccer jerseys
christian louboutin outlet
oakley sunglasses
michael kors outlet
thomas sabo uk
louis vuitton outlet stores
lebron shoes
michael kors outlet
tiffany jewelry
true religion outlet
mulberry bags
cheap jordans
longchamp outlet
versace sunglasses
beats by dre
20160507caihuali

Unknown said...
on 

tommy hilfiger outlet
adidas outlet
nhl jerseys
true religion jeans
cincinnati bengals jerseys
louis vuitton outlet stores
gucci outlet
louis vuitton handbags
true religion outlet
michael kors handbags
toms outlet
michael kors outlet clearance
adidas ultra boost
uggs outlet
lebron james shoes
hermes handbags
coach outlet
gucci handbags
michael kors handbags
jordan retro
replica watches for sale
ralph lauren outlet
timberland outlet
adidas yeezy
nike air max pas cher
ugg boots
michael kors handbags
oakley store
louis vuitton
jordan 4
fitflop sandals
toms shoes
ugg outlet store
vans shoes outlet
toms shoes
adidas trainers
uggs australia
gucci bags
jordan 6
hermes birkin bag
chenlina20160902

chenlina said...
on 

20180612xiaoke
tory burch outlet store
kate spade outlet store
manolo blahnik
coach factory outlet
coach factory outlet
canada goose outlet online
nike nba jerseys
polo pas cher
true religion jeans sale
jordan shoes

Unknown said...
on 

Post a Comment