[belajar-access] Koneksi MS Access tampa odbc [2 Attachments]

 

[Attachment(s) from muzakkir nasruddin zakirnas@yahoo.com [belajar-access] included below]

aslm sekedarinformasi

 

Keneksi MS Access  MySQLtanpa menggunakan odbc

 

Unduh file vbMysql Direct : https://dl.dropboxusercontent.com/u/75886781/vbmysqldirect.rar

kemudian install

1. buat project ms access

2. buka jendela vba

3. buat koneksinya

 

contoh : vba

 

Private Sub Command0_Click()
Dim oConn As New MYSQL_CONNECTION
 'Dim rs As New MYSQL_RS

Dim server As String 'variabel string untuk server database
Dim UserDB As String 'variabel string untuk user login mysql
Dim password As String 'variabel string untuk password mysql
Dim database As String 'variabel string untuk namadatabase

server = "localhost"
UserDB = "root"
password = ""
database = "c187ppmg4_db"
 
Set oConn = New MYSQL_CONNECTION
oConn.OpenConnection server, UserDB, password, database

MsgBox "Anda telah terkoneksi dengan database " & database
oConn.CloseConnection
Set oConn = Nothing

End Sub

selamat mencoba semoga bermanfaat

 

__._,_.___

Attachment(s) from muzakkir nasruddin zakirnas@yahoo.com [belajar-access] | View attachments on the web

2 of 2 Photo(s)

1.bmp

2.bmp

---

Posted by: muzakkir nasruddin <zakirnas@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Check out the automatic photo album with 2 photo(s) from this topic.

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

SPAM IS PROHIBITED

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___