Forum Discussion
Constant database conflicts
Well, ONE option certainly is to go to a VPN, but I'd hardly say you "have" to take that path. Many organizations do that very successfully, of course. I would NOT try to run such a setup with the FE on your home computer and the BE in the office. In my experience, performance is marginal. When I had to do that, it was okay for me, as a consultant, to log in for a brief maintenance/trouble-shooting session, but I wouldn't ask a user to do that all day every day for their regular work.
Remote Desktop works great. In that scenario, there needs to be a dedicated computer inside the office for each user, though. In other words, available hardware is going to be a factor. That said, it's much better performing where it can be done. You could also set up Remote Desktop server but I have no experience with that and can't speak to how well it would fit your scenario.
There is at least one other option to consider, remote hosted SQL Server or other server-based database (MySQL, etc.) Performance is a consideration, as is cost, but it eliminates the need for having in office computers dedicated to external users.
- Thanks George, that might be the solution. We already have desktops in the office for everyone. We would just have to remember to turn them on. I'll do some more research and give it a try. Thanks again for your help.
