So at this new company I've been working at they have quite a few reports that they run in Microsoft Access. They're just standard forms that run queries and have some Visual Basic in the background. Or so I thought.
Once we swapped to the new server I had everything copied from one to the other so that we could ditch this 1996 server. Well it turns out that when you copy and paste a Microsoft Access database that has ActiveX controls, that you have to register, they don't copy over correctly. When you open up this newly copied database you'll see the blank white space where the object is supposed to be. In my case these were the Microsoft Data Grid and the Microsoft Date Time Picker controls.
The only fix...Delete the old object, re-register the ActiveX control, insert a new object and re-name the ID to the old object. Then everything will start to work again. What a mess.
Not to mention little things like the VBE6.DLL file which may need to be updated if you're using Access 2000, which this company is. When you people do your coding, make sure to document, and I mean document, document, document. I've easily wasted an extra week working here, just trying to relearn the things they should have known about.
Documentation is wonderful.