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?
- 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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can delete it yourself - just click the Delete link near the original question posting.
ASKER
Scott...
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!.
Thanks!!
I will likely leave it open for a little longer, now.
Would rather assign points than cancel.
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!.
Thanks!!
I will likely leave it open for a little longer, now.
Would rather assign points than cancel.
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.
Scott
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.
Scott
Ditto everything Scott said.
Jim.
Jim.
ASKER
Ha!! so now you could say you're both "pointless"!!??
(Sorry - had to)
(Sorry - had to)
Quite a few people would already say I'm pointless!!!!
ASKER
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.
ASKER
Great response and quick!
As posted already I am closing on basis of expected best answer(s).
As posted already I am closing on basis of expected best answer(s).
ASKER
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.