[belajar-access] Meningkatkan perform access di jaringan

Dear warga milis,

 

1. Saya ada baca di help ttg meningkatkan perform access di :

• You can greatly enhance performance when opening the main database and opening tables and forms by forcing the linked database to remain open. To do this, create an empty table in the linked database, and link the table in the main database. Then use the OpenRecordset method to open the linked table. This prevents the Microsoft Jet database engine from repeatedly opening and closing the linked database and creating and deleting the associated .ldb file.

 Mohon mgkn bisa lebih diterangkan, maklum daya tangkap dan ilmu msh kurang...

 

2. Untuk access di jaringan apakah lbh baik kita memakai system record yg diedit ter-  save setelah user meng-klik commandbut "save" ? ataukah yg default access aja yg auto save begitu kita edit record. Bila ya, mohon dijelaskan bagaimananya caranya membuat form yg tdk auto save tsb ? kalau bikin command but "save" bisa…(ada wizardnya..hehehe..hidup wizard !)

 

3 Apa fungsi Recordset Type ?…disitu ada pilihan snapshot, bagaimana kita memanfaatkannya supaya perform access bisa lebih meningkat..?

 

Sekian, maaf bila "mborong" nanyanya.. J

 

Regards,

Hendra

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___