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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Aug 13 16:13:23 CDT 2013


Agreed.  I'd be very wary of running bound forms over the internet.

-- 
Stuart

On 13 Aug 2013 at 14:05, Francisco Tapia wrote:

> 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
> >
> -- 
> 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