Changing the database connection programatically.

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.
 
I

Indra

Thanks Brian,

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

thanks again for your help.

Indra.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top