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