[AccessD] Access 2007 to SQL Server 2008 over the internet(Cross Posted)

I haven't worked in Access for some time now, but one thing to keep in mind
is that Access used to create at least 3 connections for each session,
which works well on a quiet, fine tuned network, but over a latency
internet connection could be problematic.  If you swap out the default
connection objects in Access and unbind each form, and instead create ado
connections back to Sql Server, you might be able to combat these latency
issues if they should arise.



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




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

> What I was thinking of doing was to run the Access FE from the users laptop
> or desktop and host the data on a SQL Server.  I also have an ASP website
> connected to the same data on the SQL Server.
>
> Worst case, I was hoping to demo the entire project to prospective clients;
> best case, I was hoping to host the entire project for clients.
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Tuesday, August 13, 2013 12:46 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access 2007 to SQL Server 2008 over the
> internet(Cross Posted)
>
> When you say over the internet, are you talking about cloud services or
> something else?
>
> Charlotte
>
> On Tue, Aug 13, 2013 at 6:25 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.
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3392 / Virus Database: 3211/6574 - Release Date: 08/13/13
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>