Database will not open using VPN

[wchelly]

I can open and use my Access Database when in the office and on the network, but it will not open when I am off site using VPN.

I moved the database to a different folder on a different server in a different city. When I ran the test, it worked for remote users. Now it does not work at all for remotes.

It would not be a permissions issue since it works in the office.

I set up a test folder with some PDF files, and at least some users can open the test folder remotely, but this access database does not function at all for these users.

I'm just not sure how to make it work for them.

 

[wchelly]

>>The reason VPN users cannot access the directory is due to the fact that you must use the fully qualified domain name.
It is unclear to me why this would be true only for remote connection. Any ideas?

 

[mdlueck]

When connected via VPN, are the required drive mappings the same as they are mapped when in the office?

 

[wchelly]

When off-site, it times out while searching for the mapped drive. Basically it takes too long.

 

[mdlueck]

In that case I think you know what your problem is... connection speed, not Access.

 

[wchelly]

My solution was to link to the back-end tables through a direct connection to the folder in which it resides. Using a mapped drive causes it to time out.

The mapped drive is faster in the office.
The direct network path is faster on VPN.

Thanks for the assistance!

 

[mdlueck]

Thank you for returning to post the work-around that works in your case. I am pleased that a solution was found.