Add or comment out the line
deb file:///cdrom/ sarge main
to the file /etc/apt/sources.list Make sure 'sarge' is replaced with etch or sid if you use those repositories. Besides main, add contrib and/or non-free if you want to use packages from those branches.
To upgrade your distro enter
apt-get update && apt-get dist-upgrade