Linking tables across firewalls

[Ed Morra, MSME]

Our goal is to link tables in a microsoft access database on our labs
internal server to another table in a .mdb file on our ISPs webserver in a
secure manner through each servers firewall. The goal is for our internal
users to have the same user experience using acccess regardless of the
physical location of the underlying data tables.

What technologies might best get us there? RDS? XML? SOAP? A VPN tunnel?

Thanks in advance,

- Ed Morra -

 

[John Nurick]

Hi Ed,

See http://www.attcanada.net/~kallal.msn/Wan/Wans.html for why this is
not the way to go<g>.

 

[Ed Morra, MSME]

Thanks for this excellent lead John! After reading this it sounds like we
would have to "upsize" our Jet db engine to MSDE or SQL to be able to use a
small and/or intermitant bandwidth type WAN connection to link tables.

What are some techniques to link MSDE or SQL tables across the Internet to
another MSDE or SQL table at a firewalled webserver?

- Ed Morra -

 

[John Nurick]

Hi Ed,

I don't know what if any linking is possible at the SQL Server level,
but if you're using Access as a front end, as far as I know there's no
problem connecting to more than one SQL Server database at a time using
(I guess - this is beyond my expertise) ADO.NET or perhaps ADO.

Thanks for this excellent lead John! After reading this it sounds like we
would have to "upsize" our Jet db engine to MSDE or SQL to be able to use a
small and/or intermitant bandwidth type WAN connection to link tables.

What are some techniques to link MSDE or SQL tables across the Internet to
another MSDE or SQL table at a firewalled webserver?

- Ed Morra -

 

[Joe Fallon]

If you can see the SQL Server you can link to it from SQL Server.
I link to servers hundreds of miles away over the Internet and it works
fine.

SQL Server calls them Linked Servers. <g>
--
Joe Fallon
Access MVP

Thanks for this excellent lead John! After reading this it sounds like we
would have to "upsize" our Jet db engine to MSDE or SQL to be able to use a
small and/or intermitant bandwidth type WAN connection to link tables.

What are some techniques to link MSDE or SQL tables across the Internet to
another MSDE or SQL table at a firewalled webserver?

- Ed Morra -

Hi Ed,

See http://www.attcanada.net/~kallal.msn/Wan/Wans.html for why this is
not the way to go<g>.

in