I had the same issue and found that if the N800 is connected to a USB, you will get a "No Memory card inserted" message. If I disconnect the USB cabled from the N800 and restart File Manager, the SD cards are available.

Hope this helps.