Dear master access,
Mohon pencerahan seputar backend mysql (FE msaccess),
Saat ini saya mencoba membuat msaccess MySql Database starter/Launcer (istilah sendiri) yg langkah kerjanya menjalankan mysql service lewat command prompt
Selama ini saya menjalankan start service mysql manual lewat command prompt (net start mysql),
& ketika dicoba membuat DB launcher ini, saat menjalankan service lewat form msaccess menggunakan Shell (Environ("comspec") & " /c net start MySql ", perintah itu langsung menjalankan service tanpa mengecek apakah service tsb sudah terpasang dengan benar / belum.
Mohon maaf jika istilahnya agak aneh berhubung pemula banget di msaccess, intinya langkah Database launcher sbb :
1. Menjalankan DB Launcher
2. Mengecek apakah service MySql sudah terpasang / terinstall
3. Jika sudah terinstall, lanjut menjalankan service .. net start MySql
3.1 mengecek proses start service MySql sampai selesai , setelah komplit, docmd.openform “FrmMain”, dengan status txtStatus “ Mysql is Running on Port 3306”
3.2 jika form di close / exit application , jalankan perintah .. net stop MySql
4. Jika belum terinstall MySql, muncul msgbox “Database belum terinstall, tolong cek konfigurasi database”
Terima kasih atas semua masukannya
Regards,
Deden
"This email message and information, including any attachment is intended solely for the use of the recipient(s) and are confidential and may also be privileged. If the reader of this message is not the intended recipient, please delete this email and all information it contains including its attachment from your system and immediately notify the sender. Dissemination, distribution, copying, or other use of this email or its attachment is strictly prohibited. Any unintended use of this email shall be your responsibility and shall be subject to any jurisdiction."
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar