Dear All,
Saya mau tanya donk, program saya pakeDatabase Ms. Access di sharing di
Jaringan, tetapi kok sekarang lama, yaa....
Program saya dipakai oleh 10 user dengan record saat ini sekitar 3000
record.
Lama sekali program diakses, Saya pake DAO 3.6, Script saya sbb :
Dim Db As Database
Dim Rs As Recordset
Set Db = DBEngine.Workspaces(0).OpenDatabase("Z:\\BLProject\DBBL.mdb",
False, False, ";pwd=pasword")
Set Rs = Db.OpenRecordset("SELECT * FROM USER WHERE User = '" &
TxtLogin(0).Text & "' AND PASSW='" & TxtLogin(1).Text & "'", dbOpenSnapshot)
..
...
...
....
Rs.Close: Set Rs = Nothing
Db.Close: Set Db = Nothing
Apakah ada yang salah ? mohon info nya..
Trims sebelumnya
Rgds/ Ridwan
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/
<*> 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/
