In addition, if you use Vista or Windows 7 and you have more than one
version of Access installed, your UAC (User Access Permissions) may be
getting in the way. If UAC is enabled, then Access does not have the
permission to load the library objects it needs and so will use the
last ones used -- which likely are for the wrong version of Access!
This will cause problems as you try to open or run forms or reports in
the database. You can try to change the registry to always allow
Access to run with administrative permissions but I found this did not
work. What did work was turning UAC off. This solved the issue
completely. Turning off UAC is NOT the best idea as it can expose your
PC to malicious threats.
See Allen Browne's website for some other alternatives that may work
for you: See http://allenbrowne.com/ser-38.html and http://allenbrowne.com/bug-17.html.
He provides excellent information and suggestions on how to work
around this bug.