perintah tersebut selalu dilakukan pada setiap mau open tabel ato pake timer ya ?
Tx Lai Min Feng wrote: > > if not db is nothing then > if db.state=adstateopen then > db.close > end if > end if > > kira2 kaya diatas (belum dicoba, tapi mestinya bener) > ======================= > http://www.fire888.com <http://www.fire888.com/> > > -----Original Message----- > *From:* [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of *Sumardi Mardi > *Sent:* Thursday, July 26, 2007 8:07 AM > *To:* [email protected] > *Subject:* [Programmer-VB] Status Koneksi ADODB > > guys .. > > gimana cara mengetahui apakah sebuah koneksi yg dibuat dengan > ADODB itu sedang terbuka / terpakai atau tidak. > > soalnya perintah untuk compact / repair database itu ... semua > connection kan harus tertutup ... > sehingga perintah db.close (db adalah connection) ... akan error > jika db tersebut belum di set atau memang sudah tertutup ... > > satu lagi .... perintah On Error Resume Next ... koq sering gak > respon .... ada yg bisa kasih pencerahan ?? > > trims > mardhie - papua > > ------------------------------------------------------------------------ > Park yourself in front of a world of choices in alternative vehicles. > Visit the Yahoo! Auto Green Center. > > <http://us.rd.yahoo.com/evt=48246/*http://autos.yahoo.com/green_center/;_ylc=X3oDMTE5cDF2bXZzBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW4tY2VudGVy> > > > > Messages in this topic > <http://groups.yahoo.com/group/Programmer-VB/message/26639;_ylc=X3oDMTM2amJxaTNvBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY0BG1zZ0lkAzI2NjQwBHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTE4NTQyODMxMQR0cGNJZAMyNjYzOQ--> > > (0) > <http://groups.yahoo.com/group/Programmer-VB/post;_ylc=X3oDMTJxbDBpMW4yBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY0BG1zZ0lkAzI2NjQwBHNlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTE4NTQyODMxMQ--?act=reply&messageNum=26640> 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 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Programmer-VB/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
