When you copy a database to a CD, it converts the database to a read-only format (ie, when you open the database, you will get a message that the database is read-only).
It will work, but you if you have any tables that need to have data entered, either directly or through forms, you will not be able to enter it (unless you have a cd-rewriter, which then makes everything possible).
Your only option would be to copy the database from the CD to the local hard drive and remove the read-only attribute from the database (right-click on the file and select properties).