What I would like to do is put a re-writable CD into the CD drive and leave it there. Access would copy it's back end onto the CD every day (say at 3 AM).

The "network" is the PC. Others link to it.

I've done a search and checked a few other places but no one seems to cover this.

I would like to keep it in Access but if I have to do somthing in Windows I will.

Using Access 2003 and WindowsXP Pro

Thanks

Your question has been asked before but I do not think that anybody has ever posted a solution that can be done with VBA.

The Nero BackItUp (http://ww2.nero.com/nero6/eng/Nero_BackItUp_Features.html) program will do what you want. You can buy Nero for less than $100.