Greetings,

I have a Problem that is really nagging me. I have a VB app that is trying to get data in an Access 2000 .mdb

here is a code snippet
Code:
  
    adoDriver = "Driver={Microsoft Access Driver (*.mdb)};"
    adoPath = "dbq=" & DataBaseLocation & ";"
    adouser = ";"
    adoPassword = ""

    Dim rs As ADODB.Recordset
    
    ' used temporarily until code is working   
    strConnection = adoDriver & adoPath & adouser & adoPassword
    
    On Error GoTo handleErr
        dbCheckOut.ConnectionString = strConnection
        dbCheckOut.Open
        cmCheckOut.ActiveConnection = dbCheckOut
        cmCheckOut.CommandText = "select * from Machine"
        rs = cmCheckOut.Execute
    On Error GoTo 0
dbCheckout is the connection object
and cmCheckout is the command object

Both are declared public


The Problem is that the rs = mcCheckout.execute is saying invalid use of property and I have not clue as to why. I have looked in Technet and even downloaded a sample app from MS. And the sample code was "identical". And the references were nearly identical. Anyone have a clue as to why?

Thanks much
-=D=-