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
Re: dynamically connecting dataenvironment
try this after the process
if de.rscommand.state=1 then de.rscommand.close
Re: dynamically connecting dataenvironment
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
Re: dynamically connecting dataenvironment
just the same, if the state of your connection is open have to close it,