I have built our viewing software into a Access97 database. I can get the file to load ok. But I need to be able to drop part of the file name to get this to work correctly. Example: file name: 2243-b.dwg
I need to drop the "b" (2243-.dwg) without having to rename 35000+ files. Is it this possible?