Oct 3, 2001 #1 CyBrGhost Technical User Oct 3, 2001 3 0 0 PH pls help me ho to us database(acess) n VB i forgot how... pls urgent were having our thesis ..... Ghost....
pls help me ho to us database(acess) n VB i forgot how... pls urgent were having our thesis ..... Ghost....
Oct 3, 2001 #2 harmmeijer Programmer Mar 1, 2001 869 0 0 CN Add a the reference Microsoft Active X data Objects 2.5 library to the project. dim m_Connection As New ADODB.Connection dim rsRecordset as new adodb.recordset m_Connection.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myAccessMDB.mdb;Persist Security Info=False" m_Connection.Open rsRecordset.Open "SQL query or table name",m_connection,cursortype,locktype,options Upvote 0 Downvote
Add a the reference Microsoft Active X data Objects 2.5 library to the project. dim m_Connection As New ADODB.Connection dim rsRecordset as new adodb.recordset m_Connection.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myAccessMDB.mdb;Persist Security Info=False" m_Connection.Open rsRecordset.Open "SQL query or table name",m_connection,cursortype,locktype,options