Hi,

I have sql server 2000 on windows 2003 server, no IIS nothing else.
I am developing front end app in MS Access 2007.

Now I want to deploy front end at client pc which is in an other city and my server is in an other ...

client has internet through Dailup.
Server is on LAN.

Can any one tell me what i need to install and how to connect client to my Server ?

please help me....

__________________
Stay Beautiful,
Abdul Salam

If the SQL Server does not have an external IP address and the Client does not VPN into your network, you cant.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Server has Static IP as wel local LAN IP.

Stay Beautiful,
Abdul Salam

Then you just need to enable remote connections on the SQL Server
http://forums.microsoft.com/MSDN/Sho...02150&SiteID=1

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========