Transfer Spreadsheet to CD

[kshadden]

I have been trying to run a transfer spreadsheet macro that transfers all the data in my tables to my f drive (cd-rw). It won't go and all I get is that my database is read only. What should I do? I am using Access 2000.

 

[sfm6s524]

Okay, what does your macro have in it? Is your F: drive setup as a writeable device (i.e. from Explorer?)

Ken

 

[kshadden]

In my macro I have a message box tha comes up that tells the user to place a cd in the f drive and the user clicks OK. Then the macro goes through 9 transfer spreadsheet routines to back up the data from each of the 9 tables in the database. The actions in each of the transfers are Import, microsoft Excel 8-9, the table name transfering data from, the file name on the f drive (i.e. f:\company),
and yes for field names. However, you mentioned whether my f drive was set up in Explorer properly. How do I do that???

 

[sfm6s524]

I think you need to set the "Transfer Type" of your TransferSpreadSheet commands to Export.
If you can copy a file to your F: drive via Windows Explorer, you should be ok. Some CD writers have their own goofy software programs for copying files to CD.