derek:b3studios

Access 2007 .Transfer bug, the fun…….

I just spent 20 hours of my life, debugging one hell of a problem in Access 2007. I thought I would share this with you, incase anyone else maybe tearing their hair out - and the problem is similar.

Here is the setup. Access 2007 Database - Upsized/Migrated to SQL Server (2008 in my case). Everything worked fine before, exporting a Text File, or a Spreadsheet of the data. Now when you click on the button - It crashes the application. The stranger part - it doesn’t happen EVERY TIME!?

No in fact this problem, doesn’t even happen if you use the OutPutTo function instead…….

So after, all the tinkering eliminating the much more obvious offenders, what was the little damn stinker?! A UnionQuery…. A pesky UnionQuery was bombing out the .Transfer. It worked fine when I ran it, Access didn’t complain about it, nor did SQL server.

What I found was a pesky little ORDER BY on one of the UNION members. This trashed the .Transfer for some reason. SO there you have it. Remove your ORDER BY in one of your UNION statements, and life should be grand again!

Unlimited Data Plan from T-Mobile works with iPhone for 9.99!

So you don’t need 3G? You want email, some light web, google maps, pandora, low quality youtube, and iheartradio (or mobile streaming radio). Then T-Mobile’s Unlimited Edge plan is perfect for you.

Most people are tearing their hair out after giving up their much loved T-Zones by mistake, or for temporarily switching a phone, where T-Zones wouldn’t work correctly. Then you wanted to go back, and viola it was no longer an option. Most people tried the Web2Go for 9.99 and got the not compatible screenie, yikes! WTF?!

Behold T-Mobile Internet for Phones. 9.99 for 100 MBs, yup that sucks. But as everyone knows, if T-Mobile doesn’t have a plan for your phone, this is what your going to be offered. However, if you do a little digging, you will soon find another 9.99 Data Plan, with UNLIMITED access. This plan uses the Internet2.VoiceStream.Com APN for access.

The plan name is the T-Mobile Unlimited Shadow data access plan. Thats right, the T-Mobile Shadow. A WINDOWS SmartPhone, with a Fav 5s home screen. Since this phone is really not pushed in to the SmartPhone market, I guess T-Mobile thought no one would notice this 9.99 UNLIMITED SMARTPHONE dataplan floating around.

How can you get it? The easiest way, is to simply log into your account, @ T-Mobile.com, select the “This is Not my Phone” option, and switch your phone to a T-Mobile Shadow. Go to Service Options, and viola 9.99 unlimited shadow data plan is now available to be added to your plan!

Sure its $4 more, but it beats whining, pleading, and endless calls to get your T-Zones back, plus it works!