There are two sets of solenoids that are bolted to the transmission, one is the shift solenoid and the other is the lockup. You might want to unbolt them and clean them out with throttle body cleaner. They may be clogged up and could cause your problem. I would also inspect the electrical connections to make sure they are not corroded to those two solenoids. Maybe clean them with electrical contact cleaner.
You can download a 94 shop manual from link i posted in the online manuals thread in the diy section. The transmission section has most of the information on the location (page 14-45). Also, adjust the shift cable via procedure shown on page 14-164.
I would also short the service connector and see if the check engine light or the D4 light flashes any codes. Use a thin paperclip to short the connector. It takes about 5 minutes to do this.
See
http://www.dhost.info/accordinfo/howto/cel.html for a good set of instructions. Remember to count both the check engine light and the D4 light.
You should troubleshoot before you tear apart the transmission.