I have an Access 2002, SP1 application that runs fine on 4 PC's, all running either Win2k and WinXP Professional. I moved the application another PC running WinXP Professional also with Access 2002, SP1 and now one of the forms that looks up a record in a table gets:
Run-time error '-2141024770 (8007007e)'
Method 'Rcordset' of object '_Form_Enter_Enter Funds' failed.
The application is using ADO 2.5 and not DAO, all the PC's have the same 'References' selected in the VB Editor under Tools. The line of code that causes the error is:
Me.Recordset.FindFirst "[AccountID] = " & enteredID
If I move the same mdb file back to one of the other PC's, it works fine.
Any ideas?
Thanks
Run-time error '-2141024770 (8007007e)'
Method 'Rcordset' of object '_Form_Enter_Enter Funds' failed.
The application is using ADO 2.5 and not DAO, all the PC's have the same 'References' selected in the VB Editor under Tools. The line of code that causes the error is:
Me.Recordset.FindFirst "[AccountID] = " & enteredID
If I move the same mdb file back to one of the other PC's, it works fine.
Any ideas?
Thanks