[AccessD] : Access I love it

Simon Bamber sbamber at hss.com
Wed Jul 1 10:30:58 CDT 2009


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