Charlotte Foust
charlotte.foust at gmail.com
Wed Aug 14 12:16:54 CDT 2013
Armen has some excellent tools, and he really knows what he's talking about. I met him in May at the Portland Access Users Group annual conference. Charlotte On Wed, Aug 14, 2013 at 6:46 AM, Jim Dettman <jimdettman at verizon.net> wrote: > <<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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >