dynamically connecting dataenvironment

Hi Friends,

I have a Password protected Access database
I am Trying to CONNECT DATAENVIRONMENT DYNAMICALLY From VB. every time i open report , i want my connection to be active for that time only.
i can connect using the normal way but in that way my app becomes static.

I am lost in this .

thanks
arunendra

try this after the process

if de.rscommand.state=1 then de.rscommand.close

actually i want to define the connection at run time not at design time (using a password protected access database) so that the application can always point the database no matter where it is installed

just the same, if the state of your connection is open have to close it,