Rocky Smolin
rockysmolin at bchacc.com
Tue Oct 15 08:12:36 CDT 2013
I'll check it out if the guy who owns E-Z-MRP now wants it. I'm out of the loop pretty much any more. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, October 15, 2013 4:17 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Back End in the Cloud Rocky, << mdb BE was the way to go.>> That time has come and gone though. SQL Server has changed quite a bit over the years. SQL is now pretty much self tuning and installs easily. The only real chore is setting up backup and maintenance jobs. Many products now bundle the express edition along with their installs and often include a front end to manage the admin maintenance. You really need to re-visit it. JET/ACE had a bigger niche in years past, but that niche is now very small. The cases where it makes sense to use it are few and far between. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, October 14, 2013 11:28 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Back End in the Cloud For a one-off for a client who you can support, I agree. For a commercial product like I was flogging, being sold to technologically unsophisticated users, who didn't want to have to pay monthly for support, into uncontrolled configurations, mdb BE was the way to go. Just a different product environment. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Monday, October 14, 2013 7:25 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Back End in the Cloud After being more or less forced by one of my clients to set up a SQL server BE for an Access FE, I am now a convert. It's faster and more reliable. Setup is fussier, and there is definitely a learning curve, but it sure works! Two years, not one corrupt BE. LinkedIn has an 'MS Access with SQL Server' group, with lots of good tips. Doug On Mon, Oct 14, 2013 at 3:35 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > This is for a commercial product (the one I just divested myself of in > March) aimed at small manufacturers. So SQL is really to much horse > for that cart. And requires a level of expertise to maintain that > Access finessed for me. So for that kind of app the mdb BE works > really well. > > r > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur > Fuller > Sent: Monday, October 14, 2013 1:45 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access Back End in the Cloud > > I just don't see any point in using an MDB as a back end, and doubly > so if the BE is in the cloud or on a Terminal Services. SQL Server's > free edition or MySQL are both far superior choices, and in either > case you get the additional performance of stored procedures and views. > > Arthur > > -- > 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 -- 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