Thanks to ezan, I was using the wrong variable type.

I changed char to varchar and it works great.

Isn't it amazing how hard it is to see you own mistakes.

I have lots of clients using access with the Jet engine, they all seem to work fine with the correct maintenance.  As I understand SQL and MSDE will also require...

Versions is a good place to stat.

If any pcs are running different versions of access or different service packs you can have real problems.

Watch out for 2000 and XP as...

Your compiled program probably does not like nulls, so adding the space enables their joins to work correctly.

There is a couple of ways to deal with this.

If you can modify...