terima kasih sarannya. saya sudah pernah coba, tapi ada kendala. bagaimana jika seorang user yg sedang login, tiba-2 hang pc-nya, atau ada listrik mati. bukankah data yg di-insert belum di-delete ? ada saran melihat situasi seperti ini ?
terima kasih saran berikutnya. ----- Original Message ----- From: Wahyu Kurniawan To: [email protected] Sent: Thursday, May 05, 2005 6:56 PM Subject: Re: [indopb] Jumlah koneksi dalam 1 database Gimana klo cari mudahnya saja??? Coba buat table temporer untuk menampung user yang sedang login. Ketika user melakukan login, maka insert ke table tersebut. dan jika sudah keluar dari aplikasi, maka hapus lagi dari table temporernya. Saya kira itu lebih gampang secara teknis. Setiawan Santosa <[EMAIL PROTECTED]> wrote: rekan2 PB, mohon bantuan untuk mencari tahu berapa banyak user yg login ke database access saya. saya pernah baca artikel kalo dengan 1 sql statement ( bukan stored procedure ), bisa diambil banyaknya user yg login. Statementnya sbb : select DB_Property('Alias') as Alias, DB_Property('ConnCount') as ConnCount, DB_Property('DBNumber') as DBNumber, DB_Property('File') as File, DB_Property('Name') as Name, DB_Property('Number') as Number, DB_Property('PageSize') as PageSize from dummy Saya kira "dummy" tidak dikenal di Access. apakah ada solusi lainnya, atau modifikasi statement diatas ? terima kasih.. [Non-text portions of this message have been removed] ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Wahyu Kurniawan, A.Md. HP : 08561884559 --------------------------------- Yahoo! Mail Stay connected, organized, and protected. Take the tour [Non-text portions of this message have been removed] ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
