[dba-SQLServer] Access 2007 to SQL Server 2008 over the internet(Cross Posted)

Francisco Tapia fhtapia at gmail.com
Tue Aug 13 09:23:05 CDT 2013


Hey Jeff,
  I've worked on a project that involved over the internet connection to a
database server, and while it's feasible, however, it's not always reliable
because it depends on your internet connection to your server.  You will
want to build in a solution on what the system should do if it can't commit
it's changes.

With MS Access it doesn't seem to handle a sudden disconnect gracefully, so
you will want to build something in to know what to do if you get suddenly
disconnected such as local caching, then bundling the data and transferring
to the server once a connection is restored.

--
Francisco




-Francisco <http://twitter.com/seecoolguy>




On Tue, Aug 13, 2013 at 6:21 AM, Jeff B <jeff.developer at gmail.com> wrote:

> Does anyone have experience doing this?  I have a need to test it out for
> reliability and feasibility.
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


More information about the dba-SQLServer mailing list