Hello,
I have a database that links to 4 Sybase databases on 4 separate servers. I've gotten as far as being able to modify the registry to tell Access which server it should go to. The problem I am running into is this: the link requires another program to run to create the connection. (dbclient.exe) Before I can move on to the next server this program has to close in order for the update to the registry to be made.
Is there anyway that I can close the dbclient.exe from within my module?
Thanks for your help!
-Elysynn
p.s. I've tried to accomplish this using a DSN-less link to no avail to avoid having to open this additional program.
I have a database that links to 4 Sybase databases on 4 separate servers. I've gotten as far as being able to modify the registry to tell Access which server it should go to. The problem I am running into is this: the link requires another program to run to create the connection. (dbclient.exe) Before I can move on to the next server this program has to close in order for the update to the registry to be made.
Is there anyway that I can close the dbclient.exe from within my module?
Thanks for your help!
-Elysynn
p.s. I've tried to accomplish this using a DSN-less link to no avail to avoid having to open this additional program.