Check your Prefs in LR: Edit | Preferences | Import Tab, make sure "Show import dialog when memory card is detected" is checked.
In addition, if autoplay is disabled for that particular drive letter. Lightroom will fail to automatically import:
Windows XP: My Computer | Drive | Properties | Autoplay Tab
Vista: Control Panel | AutoPlay
hope this helps - John