>> I want to create a procedure that would verify if the information of the database it's stored in hard disk or in my CD-Rom. << 1. extract the drive letter from the file name 2. DISKSPACE(driveletter) will give 0 on a CD ROM and (hopefully) >0 on a hard disk.