Backup DB to CD/DVD

ChipperT

Banned in 13 Countries
Local time
Yesterday, 21:19
Joined
Jun 1, 2010
Messages
347
Ok, this one might be a little esoteric but I thought I would give it a try. A client has asked me to develop an Access 2007 application for him. The database and application are no biggie. But here is what I need ideas on. This will be a dispersed and disconnected db and app (not shared over any network, etc). There will be approximately 15 instances. The client wants the db backed up at the end of a session in each case when 100+ cummulative transactions have happend. Again no big deal. BUT the client wants the backup to AUTOMATICALLY go to CD or DVD without extra user work. So, I have to detect what drive the CD/DVD drive might be (there is no "standard" drive lettering scheme on each computer). I have run into a wall trying to figure this one out. So help would be appreciated.
 
Ok, this one might be a little esoteric but I thought I would give it a try. A client has asked me to develop an Access 2007 application for him. The database and application are no biggie. But here is what I need ideas on. This will be a dispersed and disconnected db and app (not shared over any network, etc). There will be approximately 15 instances. The client wants the db backed up at the end of a session in each case when 100+ cummulative transactions have happend. Again no big deal. BUT the client wants the backup to AUTOMATICALLY go to CD or DVD without extra user work. So, I have to detect what drive the CD/DVD drive might be (there is no "standard" drive lettering scheme on each computer). I have run into a wall trying to figure this one out. So help would be appreciated.

IMHO, the bigger issue will be in what software to use to write the the CD/DVD.

Some "burning" software will allow a CD-R/CD-RW/DVD-R/DVD-RW to be mounted and accessed link a normally drive once it has been formatted. Do all the systems have software installed that will allow this?
 
Ooops, left that out. Yes, they are all Windows 7 with Cyberlink ToGo software installed. If I am not mistaken, Windows 7 will allow a CD/DVD to write files natively without additional software though?
 

Users who are viewing this thread

Back
Top Bottom