Click to See Complete Forum and Search --> : Use MS Access Database on FTP


himverma2005
10-19-2007, 07:44 AM
Hi all
I am really enjoying this WebSite, and Continous support.
It really help me a lot.
Now Again I have a query. The problem is that:
I have VB Application and Database in MS Access which connection using ODBC. Now I am assign to share this database in Delhi and Banglore office. I do not have an application server I have a Web server share on some other server, they have given me IP address and web space for my web site. The idea in my mind is that: If i could copy the DB in FTP path and access it using DSN giving path of FTP but its not working now except of creating whole application again for internet does there any logic so that I can use same VB application and MS Access database in two different cities on sharing basis so that at same people from both the offices can work without any conflict.
Please help me.

buntine
10-19-2007, 11:34 PM
See this article regarding remote database connection: http://support.microsoft.com/kb/253580

Your best bet is to (if at all possible) upgrade to MS SQL Server.

Cheers.