Connect to remote Database from desktop

[Mamatha]

Hi

I developed one website in ASP and i am developing desktop
application in VB.Both MS-Access databases(website and
desktop) are maintained on the website,then how can i
connect to the remote Access database from my VB(desktop)
application.Is it possible with the Access database or is
it possible with the SQL server.
If it possible then how can i do?
please suggest me the way or any URLs related to that.

Thanks in advace

Mamatha

 

[Lucas Tam]

Is it possible with the Access database or is
it possible with the SQL server.

You can't connect to remote Access databases since Access does not have a
TCP daemon.

To connect to SQL server, use Enterprise Manager (bundled with SQL server)
or a 3rd party tool.

 

[Cor Ligthert]

Mamatha,

In addition to Lucas, you cannot direct access a msAccess database using the
Internet, however an alternative is a webservice.

See this great walkthrough how to use that.
http://msdn.microsoft.com/library/d...atingDistributedWebApplicationWalkthrough.asp

I hope this helps a little bit?

Cor