[dba-SQLServer] [AccessD] Access 2007 to SQL Server 2008 over the internet(Cross Posted)

Jeff B jeff.developer at gmail.com
Wed Aug 14 08:49:55 CDT 2013


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




More information about the dba-SQLServer mailing list