Re: Changing the database connection programatically.

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

From: Brian M. Sockey (bsockey_at_farsightsolutions.nospam.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 07:22:03 -0700

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

  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... MS just came out with a patch for ADP a few months ago ... I'm using a fairly complex database using and ADP ... the front end over a VPN connection. ... The client will either have an ADSL or SDSL broadband connection to ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... The client runs a VP from Philly to NYC. ... Would you consider using an ADP talking across an fast broadbank link to ... local database, but ideally we would like to centralise. ... the front end over a VPN connection. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... I would recommend looking at the possibility of using an ADP, rather than an MDB, but there's the distinct disadvantage that ADP may not be well-supported in the future. ... I'm using a fairly complex database using and ADP as the front end over a VPN connection. ... I have a client who has a simple Access database, which he now requires to be accessible to up to 50 concurrent users remotely over the internet, as well as a small number of local LAN users. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... Sylvain Lafontaine, ing. ... MS just came out with a patch for ADP a few months ago ... I'm using a fairly complex database using and ADP ... the front end over a VPN connection. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... MS just came out with a patch for ADP a few months ago ... ADP, rather than an MDB, but there's the distinct disadvantage that ADP ... I'm using a fairly complex database using and ADP ... the front end over a VPN connection. ...
    (microsoft.public.access.adp.sqlserver)