jneiberger,
Thanks for the idea...VPN over DSL corrupts the database. Office with server is 3.5 miles (wireless link) from a branch office where we have our ISP (cable 5 meg down x 560 something up)connected. DSL, cable, etc is not available to office with server.
I asked the programmer to try the application at the branch office connected to office with server, and it didn't work over that wireless link. I use VPN all the time to remote into the office with server, without any noticable problems, but the DB app...it's a bit much.
DirectOne and all the others,
So, I was told to find out about a T1. And I have, and I just passed along the cost...for three T1's. Someone felt the price was a too much. Sigh...now they are talking about wireless again...we have a wireless in place now and it doesn't work (running the DB from the remote location, but if you run the app via Remote Desktop on a PC at the office with server it runs fine.) And I wasn't given permission to install the current wireless link with the antennas, short coax, mast and other small details I felt were best. So, we have a omni antenna, 25 feet of LMR-400, and a somewhat wiggly mast, using an older style Cisco Bridge. Now if he wants to install another wireless link, granted with newer equipment, but with the omni's, 25 feet of coax, etc., will it work? Dunno, but I am writing the cover my but letter explaining what has happened, and what the options are.
We are using MS Access as front and back end. As I understand it, we can run this via Term Serv, but each user must have a different front end. Doesn't seem that hard, make directories, assign permissions, and test, test, test. Can't see why it wouldn't work, and it works over the wireless we have now!
Sorry, I just realized I am venting, very sorry. If anyone has any suggestions, I am opening my ears.
And I will go monitor the bandwidth while watching the users...maybe the six meg spikes were caused by users surfing the web, or something like that. Interesting how the spikes were repeated and consistent.
Thanks again everyone,
JJ