Hello, Barb:
After reading your post, I did a test. This is what I did:
1. Create a database by using MS-Access, and create a Query;
2. Create a UDL file to link the access database: I think maybe you already knew how to create a UDL file: create a blank file(any type is fine), then rename it as .UDL type;
3. Adjust a UDL property: right click the file -> Properties; goto "provider" and select Microsoft Jet OLE DB provider; goto "connection" to select your database, if it has password, input it; don't forget to test it :)
4. After that, you can link the query to mappoint by using Link Data Wizard, and it's done.

I am using OfficeXP and Mappoint 2002, so hopefully, this is workable on mappoint2001.
Hoping it is helpful.
Good Luck.