Code:
Function x()
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
msgbox "Connected...................................";
Set strConnect = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Chinku\Desktop\my-program\QUIZ.mdb;"
conn.Open strConnect
msgbox "Connected";
End Function
I want connect ms-access database. Plz clearify me about the connection and ractify the error.
Comment