Doug Murphy
dw-murphy at cox.net
Wed Aug 14 11:07:13 CDT 2013
Good move. Right tool for the job. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jeff B Sent: Wednesday, August 14, 2013 6:50 AM To: 'Access Developers discussion and problem solving'; Dba-SQL Subject: Re: [dba-SQLServer] [AccessD] Access 2007 to SQL Server 2008 over the internet(Cross Posted) OK, so after reading all of the responses, I have made an 'executive' decision. I have decided to look into rewriting the whole thing in vb.net. Sounds like some job security to me! Thanks to everyone that chimed in on this! Jeff Barrows MCP, MCAD, MCSD Racine, WI jeff.developer at gmail.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Tuesday, August 13, 2013 7:42 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 to SQL Server 2008 over the internet(Cross Posted) 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 -- 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com