ADODB.Recordset.Open - Old driver vs new driver? RRS feed

  • Question

  • Let me preface my issue by stating that I am not the person that programmed this, and I only have a limited programming background.  I am also not sure which forum this question belongs to.  I am posting here because I think it's an ADO problem.

    My company has a Microsoft Access Database that appears to be pulling information from an SQL database on a network server.  When running from an older PC with Office 2010 we have no issues.  When running on a newer PC we get the following error:

    This happens on the rs.Open line below:

    Private Sub Form_Load()
    Dim rs As New ADODB.Recordset
    rs.Open "dbo_UserAccount", CurrentProject.Connection, adOpenKeyset, adLockReadOnly


    Based on my research, I think I have narrowed it down to the reference on one PC is different than the other PC.  Or the driver(?) used to handle Microsoft Active X Data Objects is different on each PC.  Am I on the right path?

    Friday, August 2, 2013 2:54 PM