>I wondered if the problem could be with the permissions on the database. Perhaps I have them set so that the database can't be accessed at the client site? However, I'm logged in there as SA so I'd think the admin could access anything...

Anytime you do a restore, you typically have to run sp_change_users_login to re-synch the logins.