Changing the database connection programatically.

  • Thread starter Thread starter Indra
  • Start date Start date
I

Indra

Hi There,

I have migrated access database to sql 2000 with front end as adp
file. I am also using the merge synchornization with pull subscription
to the client whose is using msde 2000 in there local computer.

I am using synchronization and creation of database to each client
programatically and its working fine. When i need to change or switch
the database i can now go to file, connection and chose the computer
and all the database in that computer from access 2002 (adp), but our
client is using access runtime which doesnot ahave this facility, so I
am wondering if i can write the programm so that we can switch the
database within the local computer.

Please let me know how can i do this or is there any informamtion or
code.

Thanks for help.,

Indra.
 
Thanks Brian,

I will try this and let you know how its goes.

thanks again for your help.

Indra.
 
Back
Top