Error 2455 after Upgrading MDAC
If this is discussed in another thread, my apologies.
I'm kind of at the end of my rope here, and really hoping someone can help:
My office is currently running Windows 2000 workstations connected to a Windows 2000 server. We run an adp/ade in Access 2000 connected to SQL Server 7.0. We are in the process of upgrading to a Windows 2003 server running SQL Server 2005. We won't be replacing the workstations immediately, so we need the adp to continue working in Access 2000.
We upgraded the MDAC from 2.5 to 2.8 on the workstations so that they could communicate with the new SQL server (they couldn't when MDAC 2.5 was installed), and everything works - execpt for one command in one form. The form has an activate event that checks whether its subform is dirty before proceeding, and when that check is run I now get an Error 2455: You entered an expression that has an invalid reference to the property form/report. The code looks like this:
If Not Me.frmROC_sHrs.Form.Dirty Then
Where frmROC_sHrs, obviously, is the subform that the main form is trying to access.
Can anyone help with this? If we roll back the MDAC, and connect the workstation to the old server, this command works fine. Does anyone know why it wouldn't work with the new MDAC? Any help is greatly, greatly appreciated. Thanks!
