Darryl Collins
darryl at whittleconsulting.com.au
Tue Aug 13 19:41:52 CDT 2013
Agreed. ADO and unbound is the only way to go with this. Also move all the Access queries to Stored procs or Views Server side and call them from Access. Let SQL Server do all the work and just bring in the results to Access. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Wednesday, 14 August 2013 7:06 AM To: Access Developers discussion and problem solving Subject: Re: [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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com