Access over VPN

[altino]

Hello.
I´m new on this forum and I would like to now if anyone of you knows how to share a MS-Database over a VPN.
I´m trying to do it and I can access it with the VPN, but the problem is when I try to open it.
The answer I get is that the database is outside the network and not in a safe area.

If anyone knows whou to solve it I will be sleeping much better for some time as I been trying for a long time to make it work and there is no way.

Thanks a lot,

 

[The_Doc_Man]

I can only think of two ways to get to an Access DB over a VPN and neither of them would give that particular message. Is it perhaps a NETWORK message that is telling you the DB is unsafe?

If the VPN is statically defined such that you merely file-share over the VPN using, say, IPSEC in Encapsulating Payload mode, you should never even know the difference. Decryption is transparent to you.

If the VPN is defined via some tunneling variant of Secure Shell (SSH), you would have to be using an ODBC connection, but again, if the connection is established correctly, it should be stable and transparent to you.

That message sounds more like the network is telling you it CAN'T establish the secure connection to whatever, not that Access can't be used. Is there a chance that you are trying to use an IPSEC method in which the host holding your shared Access is not IPSEC-enabled? Or does your connection have to be relayed through a machine not IPSEC-enabled? Like an older version of Windows, perhaps?

IPSEC cannot normally be run on any version of Windows older than Win2K, if I recall my security classes correctly. If you are tunneling through another machine to your end system, all machines between you and the end system must be individually capable of supporting the VPN method you are trying to set up. I'm not sure, but I think the same principles apply if you were trying to use SSH instead of IPSEC.

 

[altino]

Vpn Still Killing Me

Thank´s for your replaying.
I Have to clarify some things that i havsn´t done on the first time.
I´m trying to access one db from one pc with windos xp to another with the same OS. And I can get trow the pc and see the db, then when i try to open it i recive the message that the db is outside the network or not in a safe place.
If this is of any help I tell you that I can access any other thing on the same directory like an excell.


Thank´s for your help Doc_Man

 

[altino]

Vpn Message

This is the message that I recive when I try to open the DB

Microsoft access can´t open this file
this file is outside of the intranet or in a place of little trust. Microsoft access will not open the file because of security problems.
To open the file copy it to you pc or in a place on the network that you can access

 

[The_Doc_Man]

This is a security settings issue. Your system must be disallowing Access because it involves some code that runs at startup. The machine on which the DB exists has been declared to be part of the general Internet rather than a trusted site or intranet site. The settings for your general Internet exploration probably have disallowed ActiveX code to run when you try to load the DB.

Normally, these security settings are controlled through Internet Explorer. But if the machine holding your DB cannot be accessed through IE (perhaps because it is not running IIS or some other hosting software), it might be harder to reset the security settings for that host.

You want to look up WINDOWS help on how to declare a particular machine to be a member of your intranet or a trusted site. This is not an Access issue, it is an IE issue. Your network admin or domain admin might be able to offer you help on the matter.