I have been reading problems and solutions on your forum pertaining to this for the last few hours and cannot get any solutions to work. I have an active x connection on my VB form with a connection to the sq2000 view that the crystal report will need. I have added the crviewer. I get the message "logon failed for user myuserid" I have supplied the user and password in the adodbc properties. I have resupplied then in a further connection definition. Somehow, crystal is not retaining these values.