[AccessD] Across across the internet

Doug Murphy dw-murphy at cox.net
Sat Jan 8 12:56:00 CST 2011


It seems that connecting to sql server is more robust. You can connect an
Access FE to SQL Azure, see
http://www.fmsinc.com/MicrosoftAccess/cloud/link-to-azure-sql-database.html.
One of the developers in our area has a product that connects over a vpn to
a remote SQL BE so it seems that this works. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Saturday, January 08, 2011 9:29 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Across across the internet

I know that the common wisdom is that Access Fe talking to an Access MDB
across the internet is a bad idea.  But what about talking to a SQL Server
BE across the internet?  The issue with the MDB is corruption.  SQL Server
doesn't corrupt, at least in the same fashion.

Has anyone tried this?

--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list