Erro in ADO RecordSet with Access database

[SRawat]

I have a applicatin in CDROM

If i run from CDROM so i geting error in record set
and if i run from Hard driv (copy app. in hard driv) it's working well

In this app useing Access database with ADO connection and recordset. I make a record set with " adUseClient "

what type a recodset i use to run

 

[sunaj]

All VB program has to be installed. This is to ensure that all necessary libaries activeX components etc. is installed on the pc.
You cannot expect a VB program to work on a random pc without installing it first. That is the way VB comes, if you don't like that you have to use another language (like C++). In VB.net this has (partly) been solved by distubuting all the necessary libaries as a part of .net. This means that if the client pc has .net installed it should be able to run without installing it first. But then on the other hand you have to make sure that the client has .net ... From plauge to cholera! Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'