Doug Murphy
dw-murphy at cox.net
Tue Aug 13 12:15:47 CDT 2013
Hi Jeff, I have done it to pull in data from a SQL server db on a hosted web server. We just use the data for reporting, so connection issues have not been a problem. If this is for doing actual work you might want to look at using client side ado record sets or connect bring your working data into temp tables and then disconnect. Connect again to update the server data. Really depends on the requirements. Doug -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jeff B Sent: Tuesday, August 13, 2013 6:22 AM To: "DBA-AccessD (AccessD)"@databaseadvisors.com; Dba-SQL Subject: [dba-SQLServer] Access 2007 to SQL Server 2008 over the internet(Cross Posted) Does anyone have experience doing this? I have a need to test it out for reliability and feasibility. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com