Jim Dettman
jimdettman at verizon.net
Wed Aug 14 08:46:14 CDT 2013
<<Agreed. I'd be very wary of running bound forms over the internet.>> Actually, one company is running apps as an Access FE with a SQL Server BE over the internet and does fairly well with it even with bound forms. They have some great tips here (which I believe I've posted in the past). See "the best of both worlds" here: http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp But what it boils down to as we have discussed in the past, is that an Access based app needs some re-work to do that well. But if your talking a Access FE to Azure (SQL Server in the cloud), it just doesn't work and I know of no one that's doing that. I also know of very few that are trying Web Apps in Access 2013. If you think Access 2007/2010 landed with a thud in regards to web stuff, Access 2013 seems to have landed with an even bigger thud. Their just too restrictive and offer no upgrade path for existing users. Personally I think Microsoft has stepped a little too far ahead of the curve this time and shot themselves in the foot. They've left no migration path for existing apps and now from 2007 on up have offered nothing new on the desktop side. I can see Access morphing into a strictly end user tool, with nothing more then being able to do web based forms and CRUD operations. Recently an entry appeared on an Access blog suggesting that for an Access Web app, *Excel* be used for reporting. That was troubling indeed. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, August 13, 2013 05:13 PM To: Access Developers discussion and problem solving 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