Selasa, 14 Juni 2016

[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
 
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)


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.
1.bmp 2.bmp

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

.

__,_._,___

Tidak ada komentar:

Poskan Komentar