I am working on a project and I am storing large amount of data in Access. I needed a quick an easy way to remove duplicate records based on a specific field in one of my tables. I thought, “This shouldn’t be too hard since there is a query wizard to determine duplicate records.”
Man, was I wrong!
After about a day of trying, I figured out the following little trick:
Make a copy of your original data table but just copy the table structure, not the data.
Edit the new table and change the field with the duplicates’s index to No Duplicates Allowed.
Save the new table.
Create an append query that will append all of the data from the original table to the new table.
Run the append query. You will see a number of warnings/errors. Simply accept them to complete the process.
Rename the original table.
Rename the new table with the same name as the original table.
You should now have all the duplicate records gone!
I have been playing around with the idea of building Internet devices for various different reasons. But, I’ve always been a bit intimidated by the process.
Moblin is an open source project focused on building a Linux-based platform optimized for the next generation of mobile devices including Netbooks, Mobile Internet Devices, and In-vehicle infotainment systems.
This is a terribly exciting prospect because by using their framework, you can avoid a lot of the pain and get on to the fun stuff!
And it looks like they have a lot of the basics already covered! Here are some important links for Moblin:
I recently received an e-mail from Sam J. with a question about flash drives:
Is their any way to record the user name of every person who has used your flash drive?
While there is no fool proof way of doing it, you could try a combination of autorun.inf files and batch file.
Create an autorun.inf file on the root of your flash drive with the following contents:
[autorun] open=getusers.bat action=Open folder to view files
Next, create a batch file called getusers.bat with the following contents:
@echo off echo %username%>>users.txt
When a user puts your flash drive into their computer, it pop up with an autoplay option indicating that they are to click on the icon to open the folder to view files. A small black box will pop up briefly and then disappear. If you go into the root of the drive, you will find a new file called users.txt. If you open this file, it wil contain the user names of all the users who have accessed your drive by clicking on the icon.
This is, of course, not a fool proof method as all someone has to do is bypass the autoplay feature and their name is not recorded or they can delete the users.txt file but this is at least a proof of concept.
I’m pretty sure that it has sunk in to the people of Microsoft by now that their deployment of Windows Vista has been an utter disaster. Vista has been out for over a year and a half now and it looks like there is only about a 14% adoption of the new OS.
This should serve as a warning for all other software developers out there and software companies. It is really easy to screw up your market and turn your clients against you.
This has prompted me to provide you with some lessons that we should all have learned from the Vista debacle.
Just because you decide you are going to lead does not mean that others will follow.
Microsoft figured they had it all figured out. Windows XP was arguably the most popular operating system on the market and the most successful version to date. Now was the time to lead the sheep clients to a bold, new OS.
Unfortunately, computer users like to think for themselves. They will not purchase something new just because they are told to do so.
Some of the more common alternatives that users went with other than buying Vista include:
Doing nothing and sticking with Windows XP
Buying a Mac
Learning Linux
Putting off purchases in the hopes that something better comes along
Lesson: Let your clients lead. Get to know what they want and put in the new options that they want, not what you think will make you money. Make the client happy and the money will find you.
Terms like “better”, “easier” and “improved” are subjective.
I will be the first person to admit that there are some definite improvements to the way that things are done in Vista. Yet, I often miss the way things were done in XP.
Microsoft has told us that Vista is better, easier and improved. Does this mean that XP was worse, harder and crappy? Of course not! So if many people feel that this is inaccurate, your credibility may just go out the window.
Lesson: Make certain that any claims you make about your new product does not reflect poorly on your old product and can be, more or less, agreed upon universally without leaving much room for opinion.
People will not change for the sake of change.
There is a certain geek element out there that want the latest and greatest in anything that you make. These are the types who stand in line for the new iPhone, even though they will not be able to get service for several months.
But, the majority of your clients do not fall into this category. Rather, they are cautious and are concerned about spending their money.
Lesson: You need to give your clients a reason to upgrade and change. Without that, they will not part with their money.
More options are not always better.
Have you ever stood in the cereal isle at he grocery store? Have you ever tried to decide which cereal to buy? It is insane how many different types and brands of cereal there are out there. Different manufacturers have knock off versions of other brands. Manufacturers try to create a new cereal by simply changing something small about one of their old cereals. It’s almost enough to make the buyer go cereal serial.
It appears that Microsoft hired all of their marketers from the cereal industry. They have split Vista into multiple editions and made the selection process so confusing people are not even sure how many editions there are. There could be four, five or six, depending on who you ask. And this does not even take into consideration OEM and open licensing. How is the average consumer suppoed to decide?
Lesson: Make your product models/editions/versions simple and easy to understand. Preferably, make one model and allow them to purchase additional options, much like the automotive inductry (but stay away from the upgrade bundle concept).
Trying to force users to upgrade will just make them find other ways of doing things.
Windows XP can no longer be purchased from Microsoft. This has been the case since June 30, 2008. They had announced that this was going to be the case back in April but they decided to postpone it. But, as it stands, you can not purchase a Windows XP from Microsoft.
Has this stopped people from selling it? No way! In fact, Dell is turning this into big business along with other companies.
Lesson: Do not try to force the hand of your clients. If they do not like your new product, they will find ways to stay with the old and send you less money in the process.
Don’t make people relearn something they already know.
With so many “improvement” in Vista, it is really difficult to know how to navigate around the system. While it may be more intuitive for a new user, the vast majority of people who will be using Vista will be those who have experience in other versions of the Windows operating system.
I know as someone who is technical, this really put me off because I’m not really interested in learning a whole new operating system, especially when I am finding it harder and harder to learn new things.
Lesson: Make your new product intuitive for both old and new users.
Make sure that those who are selling and supporting your software are on board with the upgrade.
I think that one of the biggest reason that Vista has done so poorly is that it failed to be adopted and promoted by the people who are in the trenches. I mean the techs, company computer guys, and sales personnel. Since these people were not behind Vista, they were not recommending it to friends, family and clients. This is where a new product is made or destroyed.
Lesson: Make sure that those who are speaking directly with the people who are parting with their money believe that your new product is the best version of the product ever made. Ensure that these people know as much about the product, they are excited about the product, and that they are using the product themselves every single day.
Don’t make people choose between functionality and aesthetics.
There are a very small number of people out there who will choose something useless that looks pretty over something that just gets the job done. Unfortunately, Vista, while it looks really nice, often does not get the job done.
Many people, especially those who decide to upgrade to Vista, find that the cost of all the bells and whistles means that some of their old hardware and software does not work and their system is now slower than ever.
Lesson: Focus your attention on ensuring your product gets the job done. If you have time and it is warranted, make it look pretty.
Make sure your product is ready for the market.
Even Steve Ballmer admits that they messed up the release of Vista. There are too many incompatible software packages that were critical to business and many hardware manufacturers had not gotten around to finishing up releasing new drivers for existing hardware.
All this made Vista a show stopper before people even looked at it.
Lesson: Make sure your product is usable by the largest audience possible with as few barriers to upgrade or replacement as possible.
Don’t force a hardware upgrade unless you absolutely have to.
This has goe to be one of the biggest complains made by users. Vista rarely runs well on hardware that XP was more than happy to work on. So now, the cost of purchasing Vista has just gone up significantly. This can get very expensive, expecially if they are part of a large business that has hundreds or thousands of machines to replace.
Lesson: Try to keep the collateral cost of upgrading to a minimum. Do not make people buy new products or add-ons unless they absolutely have to.
I ran across this video the other day and I thought, “That’s pretty amazing for a simple Java applet!”
This is a program called Teddy, written by a gentleman from the University of Tokyo ten years ago! I mean, really! Ten years ago I was just getting started in IT and I was really looking forward to Windows 98!This was so cool that I did a bit of research and got the actual Java program applet! If you want to play around with Teddy, the fully functional program is running below! (You will need to have Java installed on your computer for this to work!)
Left click and drag to draw, right click and drag to rotate.A full tutorial is available online.
Sorry, but I do not have the example models online.
I am working on a project and I am storing large amount of data in Access. I needed a quick an easy way to remove duplicate records based on a specific field in one of my tables. I thought, “This shouldn’t be too hard since there is a query wizard to determine duplicate records.” 
I have been playing around with the idea of building Internet devices for various different reasons. But, I’ve always been a bit intimidated by the process.
I recently received an e-mail from Sam J. with a question about flash drives:
I’m pretty sure that it has sunk in to the people of 
Just because you decide you are going to lead does not mean that others will follow.
Terms like “better”, “easier” and “improved” are subjective.
People will not change for the sake of change.
More options are not always better.
Trying to force users to upgrade will just make them find other ways of doing things.
Don’t make people relearn something they already know.
Make sure that those who are selling and supporting your software are on board with the upgrade.
Don’t make people choose between functionality and aesthetics.
Make sure your product is ready for the market.
Don’t force a hardware upgrade unless you absolutely have to.