Dan Waters
df.waters at comcast.net
Sun Jul 22 22:49:26 CDT 2012
Well - I've connected an Access FE to SQL Server across the internet via VPN using ODBC table links, and the performance was horrible - about the same as connecting to an Access file with data tables via Access table links. However, if you connect using OLEDB technology (like using Access Project), then performance across the internet via VPN is OK. I was wondering if something in Access 2013 allowed connecting to SQL Server using a connection string the same way that Visual Studio does. But that would be a violation of MS Law (Never make Access better)! ;-) Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Sunday, July 22, 2012 5:10 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2013 -- MDB Back Ends Dead? Hi Dan: I think what John means is the MS Access's very pretty interface is unaffected by the internet and if it is connecting to a real SQL server MS SQL, SQL Express, MySQL etc...; then everything is just fine as you should expect. As for a MDB DB connected across the internet, that would be madness. After a few unexpected disconnects the MDB would be corrupted and after a while, maybe a few week or two of heavy use the DB would be unrecoverable. Been there, done that and learned my lesson. (It took two or three times but I was stubborn...it is sort of like cutting on a table saw with a blind fold. You may get away with it for a long time, before you loss a finger.) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Sunday, July 22, 2012 11:53 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2013 -- MDB Back Ends Dead? John - what does 'Access FEs play nice even across the internet.' mean? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Sunday, July 22, 2012 12:28 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2013 -- MDB Back Ends Dead? >> Looks like my abandonment of the MDB format and serious investment in SQL Server (both alone and as a BE for Access projects) is going to pay off big-time. Yep. Access FEs play nice even across the internet. Win-Win. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 7/22/2012 11:23 AM, Arthur Fuller wrote: > I just picked up this from the Google+ Access Gurus group, posted by > Armen Stein, one of the MVPs there: > > "Speed is a whole different ballgame now. Since 2013 now uses SQL > Server to store the data, speed is much better, even over larger > recordsets. Also, aggregrate queries are supported again. Overall from > what I've seen, database size and speed are not concerns anymore." > > Looks like my abandonment of the MDB format and serious investment in > SQL Server (both alone and as a BE for Access projects) is going to > pay off big-time. > -- 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