Saving a Access Database to a CD-ROM

[Beckie1203]

For a project I am currently working on, I have to save the database I am producing onto a CD. The file works as it should when saved on to my computer and a USB but on the CD some of the forms do not work and a number of the VBA Sub-routines I have created are not functioning. When i say the forms are not working, I mean they can be opened in design view but not in form view.

I have tried coping the file a number of different ways, just using windows and Nero.

Advice on this matter would be much appreciated.

Thanks in advance.

 

[boblarson]

The database won't work from a CD. It is read only at that point and several things within the database (including the ldb file) need to be able to write to itself. So, you can give someone a copy on CD, but they'll have to move it to their computer for it to work (unless possibly you use InCD, or something like it, to put it on a CDRW and the person using it must have InCD installed and a CDRW writer).

 

[Beckie1203]

Thank you

Thank you for your help, I have now got it to work.