class does not support automation

F

fc

For new pc just intalled with access, it could not open
existing access file. Error massage pop up "class does
not support automation". How to set access to suppot
automation with Visual Basic?

Thanks!
 
N

Norman Yuan

Usually, it is because the Access application (*.mdb/*.mde/*.adp/*.ade)
refers to some other program (most likely, *.dll file) in its code while the
referred file is not found or registered in Windows properly.

If you cab get into its VBA IDE, click menu "Tools->References..." you may
be able to spot a referece is missing. If it is the case, you must solve the
problem by install and/or register the missing file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top