caneye
03-13-2004, 12:40 PM
I am creating an ActiveX control that will conect to a foxpro free table.
The activex will recieve a "data path" from it's parent app when activated.
I am currently connected to the free table via "file dsn". Is there any way that I can chage the data path of the file dsn at runtime?
my current code is as follows:
recordsetX.Open "Select * From freetable.dbf", "filedsn=mydsn;", adOpenDynamic, adLockOptimistic
I am able to access the table freetable but if the parent app moves the location of free table I need to be able to change the filedsn path accordingly.
Thanks in advance
Caneye
The activex will recieve a "data path" from it's parent app when activated.
I am currently connected to the free table via "file dsn". Is there any way that I can chage the data path of the file dsn at runtime?
my current code is as follows:
recordsetX.Open "Select * From freetable.dbf", "filedsn=mydsn;", adOpenDynamic, adLockOptimistic
I am able to access the table freetable but if the parent app moves the location of free table I need to be able to change the filedsn path accordingly.
Thanks in advance
Caneye