I always suggest connecting to the instance and not the actual file.

Did you add this database using the "Add New Item..." window? If so, the database file is a SQL Compact database.

If you did not add the database this way and you did install SQL Express, then you DO NOT attach the database file to the project. You connect to the service(instance), not to the file.