Mark Breen
marklbreen at gmail.com
Tue Aug 13 11:35:28 CDT 2013
Hello Jeff As Francisco says, this is easy to do but you need to take care about when you start and finish your data exchange. I have been using Access =>> ODBC =>> SQL Server for many years with no complaints. If your data is hypercritical, you need to think about batches and some way to ensure you get fully complete batches before you complete you transaction. There are lots of options but to be honest in many of mine, I just have a select or an insert and run it and it usually just works. If you can write your code so that it can just run a second time, then you will have no difficulties. Enjoy :) Mark On 13 August 2013 15:23, Francisco Tapia <fhtapia at gmail.com> wrote: > 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 > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >