how do i connect to a remote database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a website that i use to file all my clients information, the go online
and they type the information. i'm using an microsoft access database. Now,
i want to create a windows application that i can run whenever a want to
transfer the new information that is on my website database to my local sql
server database. I just want to know how do i make a connection to the
database onlie using visual studio .net 2005 or if you have another option
please let me know.

Thanks.
 
Why not use a SQL Server database instead of JET/Access on the server? It
(JET) is not (was never) designed to be used on a server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
¤ i have a website that i use to file all my clients information, the go online
¤ and they type the information. i'm using an microsoft access database. Now,
¤ i want to create a windows application that i can run whenever a want to
¤ transfer the new information that is on my website database to my local sql
¤ server database. I just want to know how do i make a connection to the
¤ database onlie using visual studio .net 2005 or if you have another option
¤ please let me know.

Do you have access to the file through the network or only HTTP?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top