dynamically connecting dataenvironment

[arunendra]

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

[kulitag]

try this after the process

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

[arunendra]

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

[kulitag]

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