You can open it (i.e., view the file listing), but you can't extract the files from it, or can you? Other programs ask for the password immediately, because they don't have the ability to view the file listing before extracting the archive.

Here's a more complete post about password encryption.