Jim Lawrence
accessd at shaw.ca
Sun Jul 22 17:09:49 CDT 2012
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