The absolute motion of the peculiar cluster NGC 6791