One server, 2 Clients help needed to access over web

[Neoki]

Hello, I am in the process of trying to get my database so i can access over the web.

Currently over the Lan I have the main database located on the server, and have created a replication for the two clients. This works over the lan where i can open the original and sync etc etc. How can i get this to work over the web so I have the same functionability as the lan method but over the web. I thought of some kind of interface but im not sure on how to do this.

Thanks in advance
Craig Clarke

 

[jeremie_ingram]

Have you considered ASP since you are going to have to run either IIS or Apache to get to it?

The Visual Studio Express WebDev is something that can assisst you.

http://msdn.microsoft.com/vstudio/express/

 

[dfenton]

Hello, I am in the process of trying to get my database so i can access over the web.

Currently over the Lan I have the main database located on the server, and have created a replication for the two clients. This works over the lan where i can open the original and sync etc etc. How can i get this to work over the web so I have the same functionability as the lan method but over the web. I thought of some kind of interface but im not sure on how to do this.

You have to implement either Internet or indirect replication. This is complicated. You probably want to consult the Jet Replication White Paper on this:

http://www.dfenton.com/DFA/Replication/Files/WhitePaper4_0_Replication.pdf
http://www.dfenton.com/DFA/Replication/Files/WhitePaper4_0_InternetReplication.pdf

as well as the Replication FAQ:

http://www.dfenton.com/DFA/Replication/Files/FAQ4_0_JetReplication.pdf

It's not simple to set up, and you may have problems with the sysadmin of your server. If it's an ISP, this isn't going to work. If it's a corporate Windows server, then it's possible, though it requires running a process on the server that cannot be used as a system service.

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/

 

[Simon_MT]

You could also consider Terminal Services however there would be some investment but it does provide an enterprise wide solution with not only the database but also all the companies files.

Simon