Microsoft Access - Object Missing with all references intact

Only had a short time to look at this issue but here's scenario...

- MS Access 2003
- Windows 7 Professional
- MDB single user DB installed on the local machine and accessed across network as needed.

Small MDB with custom forms and some VBA coding was moved from one system to a new one running same versions of Office and Windows. As expected there was a reference or two that had to be corrected. But even after this was done, when I open the MDB there is an "object missing" error when the main form tries to open. Double-checked references on another system running same and references were (or should be) OK as they matched.

The MDB is local to the new PC and does not work. But the same file, across network, does work from the PC that I checked the references on. A "compile" in VBA Editor reports no issues, although this would seem to be an object reference issue.

Am I missing something?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
First, force a refresh of the references:

1. Check any un-checked reference.
2. Close the DB and Access.
3. Re-open and uncheck the reference just checked (will be the last).
4. Close the DB and Access.
5. Re-open and compile.

 If you get a clean compile, then either DAO needs to be re-registered and/or a OCX/DLL in the system it's running on.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also, if you used any ActiveX controls, you'd have to re-insert the control on the form to make the reference "stick". To do that, open any form in Design view, insert the control, close and save the form, then reopen the form and remove the control (if needed).
DanielTAuthor Commented:
Hey guys,

Thanks for your input on this. Unfortunately I have not been back to this site as it is getting to off-season and cannot update regarding status.  Had expected to be back in or I would not have posted. Guess I need moderators to cancel the question. Sorry.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can delete it yourself - just click the Delete link near the original question posting.
DanielTAuthor Commented:

Wanted to post something first as an explanation. Owed you guys that much.
Really do try to not have "abandoned" questions. :))
But even now you're STILL trying to help!.

I will likely leave it open for a little longer, now.
Would rather assign points than cancel.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
No troubles, and thanks for the post. We certainly understand that at times you simply can't get back to the machine to do any sort of testing.

If you think you can get back to test then by all means leave it open. If not, then Delete it and open a new question when you have time to work with it. Neither Jim nor I really need any more points, so we're just interested in helping you resolve your issue.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Ditto everything Scott said.

DanielTAuthor Commented:
Ha!! so now you could say you're both "pointless"!!??
(Sorry - had to)
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Quite a few people would already say I'm pointless!!!!
DanielTAuthor Commented:
As a comment to others, this has been pending for awhile due to issues beyond my control (permission to pursue!) BUT I believe the options offered are valid and would result in a "fix" so I am going to award points on that basis.
DanielTAuthor Commented:
Great response and quick!
As posted already I am closing on basis of expected best answer(s).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.