Class does not support Automation

[Solomon]

I tried to open a database (Access) which was developed in
our organization. It Opened correctly on all machines. But
on one machine it opened however, when I tried to see
detailes on one of List Box (in the form) A message came
with "Class does not support Automation or does not
support expected interface".
What could be possible solution for this.

Best regards,
Solomon L.
..

 

[Arvin Meyer]

Usually this is caused by not having all the required libraries on the
target machine. Sometimes it is simply a matter of re-registering a library.
Go to any code window and look under:

Tools ... References

for any marked as missing. Doug Steele has an excellent page on references
located at:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

as a long shot, have a look at the Microsoft Knowledge Base article and see
if it helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;244493
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access