I receive an error "Method requery of object _Combobox failed" when opening my Access application

25 views
Skip to first unread message

dbcTech

unread,
Jan 11, 2010, 9:34:36 AM1/11/10
to Database Creations Accounting Software
We have found this message to occur if you have more than one version
of Access loaded on your workstation and you load the application
under a newer version of Access (say Access 2007) and then reopen
under an older version of Access (say Access 2003). Access retains the
reference to the wrong Object library (Access 12 instead of Access
11). You should correct this, decompile, compile and then compact the
database. This should resolve the error.

dbcTech

unread,
Jan 12, 2010, 12:13:07 PM1/12/10
to Database Creations Accounting Software
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.

dbcTech

unread,
Jan 12, 2010, 12:37:28 PM1/12/10
to Database Creations Accounting Software
One last note, changing the name of the object that causes the error
also helps to resolve the problem.
Reply all
Reply to author
Forward
0 new messages