Sorry I haven't had a chance to play with SQLCE but are you saying your trying to attach to .sdf with EM from desktop or within CE device.
See if this helps any http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road05222002.asp