[AccessD] : Access I love it

jwcolby jwcolby at colbyconsulting.com
Wed Jul 1 11:34:36 CDT 2009


 >> So far as bad designs go from past users, they have saved me loads of money in puzzle books over 
the years...

ROTFLMAO.  I never thought of it quite that way.

I generally do an analysis, and determine whether it would be cheaper to rewrite or fix.  It 
generally not not always ends up cheaper to rewrite.

John W. Colby
www.ColbyConsulting.com


Simon Bamber wrote:
> Hello All,
> 
> I have been creating database solutions since Access2 (excluding of
> Access95) over the last 20 years and have fixed many a users attempt at
> a database application, so much so that in the end, I was tasked with
> providing in-house training at one point and now have an Access
> administrator per office who is trained up to Amber status (user
> frontline and basic resolutions).
> 
> We went through the stage of banning Access which created the user
> solutions built with Excel and Word that IT was constantly called upon
> to fix so a rethink was in order.
> 
> Access was re-introduced on the basis that IT developed (with user
> guidance), Office administrators were created as frontline support
> (users took some ownership) and all solutions where built to run in the
> runtime environment only and implemented as MDEs or ADEs front-ends.
> 
> MDB back-end databases were then evaluated over time and converted to
> SQL databases.
> 
> I then took to converting the front-ends where needed to .Net and/or web
> applications for future deployment.
> 
> Access is a good conceptual design platform where can get something out
> to the user while being left alone to create a final solution.
> 
> Access is also good for tweaking designs prior to the final project
> solution and getting users to start preparing data in a way needed for
> uploading into a SQL environment.
> 
> If I could only have one tool to take on the road, it would be Access as
> upsizing is a breeze later.
> 
> So far as bad designs go from past users, they have saved me loads of
> money in puzzle books over the years...
> 
> Simon Bamber
> 
> Analyst Programmer
> 
> 
> HIRE COMPANY OF THE YEAR 2009 
> This message, and any associated files, are intended only for the use of the message recipient and may contain information that is confidential, subject to copyright or constitute a trade secret. If you are not the message recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify the sender immediately by replying to the message and then deleting it from your computer. HSS Hire Service Group Limited may monitor email traffic data and also the content of email for the purposes of security and staff training. Any views or opinions presented are solely those of sbamber at hss.com and do not necessarily represent those of the company.
> HSS Hire Service Group is a limited company registered in England and Wales. Registered number: 644490.
> Registered office: 25 Willow Lane, Mitcham, Surrey, CR4 4TS, United Kingdom.
>  
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: 01 July 2009 15:36
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] SPAM-LOW: Access I love it
> 
> Hey John
> I am agreeing with many of the points you made the other day (God help 
> me).  Let's not get into ribbons again. I consider Access to be more of 
> a developer's program than a user's program.  Most Office users haven't 
> got a clue what Access does or how to do it, that is why we see so many 
> users using EXCEL to perform activities that are really database 
> specific (and they have reams of worksheets to show for their efforts). 
> I am saddened when I see strong support for the developers lacking. I 
> consider Access (kind of  hate to be saying it) an excellent development
> 
> program. And at times I want to "spit" whenever I hear other developers 
> saying "Access! that is just a toy".  In my many years (and you and I 
> have been on this list a long long time) I have developed what I 
> consider to be some pretty powerful applications using Access. I have 
> looked at  what some of the "big boys" have developed and in many cases 
> they truly lack the vibrancy of an Access application. I can see MS's 
> point of trying to create a product that all user's will feel 
> comfortable with (marketing, marketing) but please don't do it  at the 
> expense of your loyal developer's.  Just  give us what we need.
>  
> 
> 



More information about the AccessD mailing list