I am developing application in Access 2010. However, although it works fine as an ACCDB file, when I create and run an ACCDR I get an error "Requested type library of wizard is not a VBA project".

The error message arises when switching to any tab from in the Main Navigation control that is opened when the app first runs.

The ACCDR and ACCDB versions access the same back-end data file, which is in the same directory as they are. They are both being run on the same PC.

Thanx in advance

Katy

This may not help, but go into VBA, go to Tools/references and see if anything says "missing."

I've already done that. Nothing is missing.
I've also decomple database.
I've searched in google for any possible answer, but with no luck!!!
I think that the problem is the navigation control, but I can't figure out where...

You DO know that accdr will only lauch in runtime?

Of course !!!
I've created a shortcut with the /runtime command

I'm having the same problem. Any resolution on this problem?

Hi all:

If anyone is coming here because they, too, encountered this "error" in their ACCDE when moving between primary tabs on a two-tier navigation form, this answer resolved the problem for me: (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26438281.html#a35743544).

In short, create an OnError event for the main navigation form:



Really, Microsoft, if you can't fix this problem, can't you at least publish the workaround?