Re: Changing the database connection programatically.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Indra (itimilsina_at_savannaenergy.com)
Date: 06/23/04 

Date: 23 Jun 2004 14:00:24 -0700

Thanks Brian,

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

thanks again for your help.

Indra.

"Brian M. Sockey" <bsockey@farsightsolutions.nospam.com> wrote in message news:<Or#VEo5VEHA.1764@TK2MSFTNGP10.phx.gbl>...
> Here is an article I wrote that explains how to programmatically change the
> connection of an ADP:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;306881
>
> Brian M. Sockey
> www.farsightsolutions.com
>
>
>
>
> "Indra" <itimilsina@savannaenergy.com> wrote in message
> news:e667cf1e.0406161332.3517c50@posting.google.com...
> > 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.

Relevant Pages