Hi All,
I have an access 2002 database with one table in it called "MT_ITEM_LIST" and have added the ADO 3.6 Library to my source references.
I am trying to connect to the table but my code trips up when I try to Open the recordset.
My Current code is as follows:
Public Function searchTable()
Dim dbs As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDbs("MT_ITEM_LIST")
Set rs = dbs.OpenRecordset("MT_ITEM_LIST", dbOpenDynaset)
Dim strSql As String
Dim strSQL2 As String
Dim vSearchItemRef, vSearchItemDesc, vSearchPVNb
Dim vResultItemRef, vResultDC, vResultItemDesc, vResultPVNb, vResultPVName
strSql = "My Test SQL"
Debug.Print strSql
*** CODE TRIPS UP HERE ***
rs.Open strSql, conn, adOpenKeyset, adLockOptimistic
Any suggestions for me?
Thanks.