If core is all that's allowed, don't be an archer rogue. I'd say being an archer in general is a bad plan, but archer rogue is like a double serving of weaksauce. The only possible way to make it work is Arcane Trickster, and that doesn't really come online for many levels. Namely, not until you've entered the prestige class and have lots of 4th level spells to drop on Greater Invisibility. If you really want to be a rogue, take advantage of 3E's rich multiclassing system. Drop some levels in it here and there to keep key skills maxed out till you can make the check DCs reliably, and mix with Ranger and other classes that can fight worth a damn.
Crossbow can work, but it requires an extra feat (Rapid Reload) to be viable compared to a bow.
The best core races for a rogue are Deep Halfling (in the Monster Manual), Forest Gnome (in the Monster Manual), Dwarf, and Human. Never ever play a Half-Orc or Half-Elf, and avoid Elf 99% of the time. If the Monster Manual races aren't allowed, Gnome is a decent if incredibly dissapointing replacement for its forest kin, just by virtue of being a small race with darkvision. Core Halfling is NOT acceptable, NEVER EVER take it for a rogue. A Rogue with base speed 20 ft and no darkvision is utterly worthless. Can't exactly sneak around at night with a lantern, and being in any illumination shadowy enough to grant concealment means you can't sneak attack.