You can blog better

When it comes to SEO, blogging is a must. You want to communicate what you know and how you can help your visitor with whatever it is you are offering.
Did you like that last statement?
Do you know WHY you liked it? In a word, "YOU"!
The most effective keyword you can have in a blog post or twitter post is the word “You”. “You” makes the post familiar. Using generic words like them, they, us, me and I are not as effective.
Make your articles focused on the reader, not the writer OR the product. You can only motivate your reader when they think you are talking directly to them.
Let’s be honest, people are basically interested in fulfilling their own desires. If you don’t appease them, aren’t interesting to them, offering them value, they will not be back, they will find that post that does.
So, you change your post to be directed to the reader. What happens? YOU become the next viral buzz!
Next time you blog, before you post it, count the numbers of “you” words. Count the “I” and “me” words and adjust. Make the post about and for your reader.

Access Upgrades. The Good, the Bad, the UGLY

The time has come to migrate that great Microsoft Access (MSA) 97, 2000, XP or 2003 database to MSA 2007 or 2010. There are many questions that can arise. Is it easy? Do I need a consultant? Better to rewrite or migrate? I hope to answer at least one question in this article.


The Good:

The migration process is rather easy if you are looking at a simple database or if it is nothing more than a data container. Just open the mdb with MSA 07/10 and click Upgrade. There is a table, MSysACEs, in the old access databases that will not convert as Access 07 and higher doesn’t use it. You will get an error that some objects did not migrate. Once the database opens, go to Tables, then the Conversion Errors table. This table displays all the objects that 07/10 could not migrate. If the only object is MSysACEs then life is GOOD!

The Bad:

If you have a Front-end (FE) to Back-end (BE) mdb, then the migration can take a bit longer. I convert the BE first, then the FE. Be sure and open the FE with the Shift key pressed so the application doesn’t try to run any macros or code. I spend some time on my knees HOPING there is not a ton of VBA Code otherwise I will be spending some time, hours sometimes, walking the code looking for the old MSA defaults (like A_Form) and converting them to the MSA 07/10 equivalent. Depending on the intricacy of the Application, your best bet may be hiring a professional.

The UGLY:

MSA 07/10 security is completely dissimilar to previous versions of Access. You will notice a Security Warning bar just under the ribbon. As a default, the only directory MSA allows auto execution of code and macros is the %Programs%\Microsoft Office\Office12\ACCWIZ. If you have an application running in any other directory, you will need to open the trust center and add that directory to the list of paths that MSA trusts.

These are some of the problems I have encountered when doing a migration. I have no doubt that others have hit other issues.

Runway 7L hangs on to Third Place

Tuesday night saw the Flight Line\'s Runway 7L playing the 5030 Lounge at the Flight Line bar.


Duane was started off the evening with nine wins in a row and extended that to thirteen. He is now comfortably in first place in the individual standings with 185 points.

Deb and Ruby struggled a little with getting the eight ball into the pocket. They both ended the night with 28 points and two wins each.

Rob played solid. Only winning one game, he ended up with 31 points keeping him in in the top 15.

When the dust settled, Runway 7L only won one round but is solidly in third place overall. All of the players are in the top 15 in individual points.

Next Tuesday, Runway 7L is heading to Steel Horse to take on the Guys N Dolls team. Best of luck Runway 7L.

*****************************************
**  Web sites and Custom Applications                  **
*****************************************