When I import locations from an Access database, certain addresses will plot if I select a Pushpin map, but not if I select Multiple Symbol. I don't get an error message, and it doesn't tell me that any addresses were not mapped, but it just omits them when I use Multiple Symbol.

When I try to import one of the problem locations by itself, I can't complete the Data Mapping Wizard. I select Multiple Symbol and hit Next. I select the data field I want to map. When I select "Street Address" under "Show the data by" and hit Next, I get the following error:

Data in the field or column you have chosen does not exist or is not appropriate for the selected geographic unit. Select a different field or column, or geographic unit, and try again.

What I don't understand is that if I go back and select Pushpin Map, the address plots without a problem. It appears the geographic unit selection is causing the error, but I don't know why.

Any help would be appreciated.