Cannot find column ..." Error. Broken link to SQL?
Has anyone gotten the "Cannot find column ..." and "Can't open the table in datasheet view" errors?
I have an Access2002 ADP linked to SQL2000. My main table, TblCases, used to have FileNumber (varchar) as its primary key. I changed that field to DocketNumber (varchar). At first, things seemed to be working well. But now I get the errors "Cannot find column FileNumber" and "Can't open the table in datasheet view" when I try to open TblCases in the ADP. Also, forms based on that table are giving me errors, mainly that FileNumber is an invalid field (which is strange since I've gone through them and deleted or changed every reference to FileNumber).
Strangely enough, I can open TblCases just fine in Enterprise Manager, and I created a view, ViewCases, totally based on TblCases, and that opens fine in ADP.
I checked some websites and the few references to this problem indicate that the link between the ADP and SQL2000 seems to not be working correctly, so that the table in the ADP is still looking for the old FileNumber field, while the table in SQL2000 knows that it has been replaced by DocketNumber.
Does anybody have an idea what's going on?