Can anyone explain to me why I get the following error message

"Connection 'X' is busy"

I get this error within a project when I browse a view, or it may happen when I running an executable.

I am connected to a SQL 2000 database.

It does not appear to be consistent

Many Thanks