MS Access too slow over VPN...HELP!!

[sestes]

I've searched your website and I found a couple threads regarding this situation, but nothing that can help me yet. Long story short, I work remotely from home often using a broadband connection at 100Mbps (same speed as my work connection). For most applications, the timing is virtually the same as in the office. Except, however, for MS Access. In the office, we have a local server, but we also have access to a term server at corporate HQ (states away). At home, I have access to both as well. All of my databases are stored on the local office server. Since my VPN is logging into the Main server at corporate HQ, could this be why my databases run so slow? The IT dept loaded my local server and MS Access onto the Term Serv, thinking that would increase speed. It hasn't. A query that takes 30 seconds to run in the office takes an hour at home. Should I move all of my databases to the Term Serv? I will be working from home starting in December for maternity leave and MUST get this speed increased asap. THANKS in advance for any help you can lend me!

 

[sestes]

I think I figured out my solution. What if I VNC from my home computer into my laptop at work while it is still hooked up the the system. Then everything will work just as it does in the office, right? I've just emailed IT with the suggestion. We'd tried setting up the VNC at home a few months ago, but we kept running into roadblocks and I was in a big hurry, so we quit trying and I just came back to the office that night. Hopefully this will work this time. What do you think??

 

[burtsbees]

Then why not set up a VPN connection at your local office, where access and the database are?
By the way, your broadband connection is not 100MB...that's the connection from the router/ethernet port of the MODEM to your pc, maybe...do you have a router or is it just a MODEM? If it is a MODEM, it could be operating at 10MB/half duplex, which would cause a problem.
The bandwidth all around is only as fast as the slowest link...what speed dsl connection do you have? What connection is at Corporate? What kind at the local office? If you VPN to corporate, then RDC from corporate to the local office, that creates all KINDS of latency...so try setting up a VPN server at the local office. What kind of router does the local office have? What kind does Corporate have?

Burt

 

[sestes]

I suggested that they set up a vpn to our local server and they said that it wasn't possible. Seriously not dealing with the brightest IT people here. VERY frustrating and constant turnover in the department as a whole. ANYWAY...Our local office is on DSL and I'm on Broadband at home. I'm not sure what Corporate is on. I have a modem, not a router. How would I find out at what speed I'm actually operating at while at home? When I click on my icon below, it says 100Mbps.

 

[brianinms]

To test your speed go to

http://www.speedtest.net.

You should VPN to corporate and then use terminal services to connect to the server hosting the database. It would be as if you were sitting at the server itself.