A summary of my earlier question follows:
I have several users that run my program but for some the following message
"Class does not support Automation or does not support expected
I'm aware that it can be difficult to say something about a program you
never have seen, but it is princply a simple program for transferring data
from AS400 to Access and at the same time convert some formats. I only use
textfields, lables and commandbutton. No ActiveX components.
The error starts in connection with this code:
Dim cnMovex As ADODB.Connection, rsSource As ADODB.Recordset, rsDest As
Set cnMovex = New ADODB.Connection
cnMovex.Open "Provider = MSDASQL.1;User ID=***;Password=***;Persist Security
Info=True;Data Source=AS400 analyser;Mode=Read;Initial Catalog=JMNORGE"
The user has all ODBC connections OK.
What happens and what can I do ?
Try installing the correct version of MDAC see if that solves the issue.
Jan Hyde (VB MVP)
I have checked my MDAC version against the users and the MDAC version is the
same (MDAC 2.8 SP1 on Windows XP SP2).
What else can be wrong ?
Roger A. Olavsen