Friday, November 11, 2016

Amateur Hour for the Access Solution you have just been shown ?

Armen Stein has a simple list that you can use to evaluate if a database was created by a person who has not had the time to properly learn Microsoft Access.

In the list of flaws, Armen singles out splitting, compile errors, weird field names, the lack of database relational design and popup dialogs and others. Apart from late binding of Excel which my guys leave until we do have a problem and splitting of databases which we don't do until the database goes into production, I  like Armen's Amateur Signs list , 

If you want to dive deeper into the topic of the "Less the perfect Access solution", have a read of Luke Chung's article on Taking Over Someone else's database.


That's the heavy reading over, have you ever dreamed of going to Hawaii. If so, Armen's wife Lori with a little help from Armen has written a travel guide for Kauai, the most spectacular of Hawaii's great islands IMHO.  If you have never been to Kauai, think of this book as the guide that introduces you to the great things about why you should visit the island rather than the guide that says such and such a hotel is 3 star and has good parking.

All the best and Happy Birthday MS Access

Garry Robinson
Programmer who didn't ever use Access 1.0 or 1.1

No comments: