Jim Lawrence
accessd at shaw.ca
Tue Aug 13 19:03:04 CDT 2013
>From experience it is impossible... Absolutely guaranteed corruption...of course with a real SQL DB at the BE why would anyone do that? Jim ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, August 13, 2013 2:13:23 PM Subject: Re: [AccessD] Access 2007 to SQL Server 2008 over the internet(Cross Posted) 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com