Using MS Access/Saving Access data

Advertisement


Question
I hope I have a simple question for you. I have Windows XP. I am pretty knowledgable about computers but have little knowledge of Access, Excel, Word. My question. I save an Access file to a CD-RW disc. When I open the file up from the disc, it says it is Read Only. Why can't I  change the info and save it again writing over that file? Thanks for any help.

Answer
Hi

Yeah - I've come across this before. You're writing to a read write disc and Access is treating the volume as read only.

This, I believe, is down to Access having only two read states = read only and write.

The workaround is to copy your db to the local drive make your changes then rewrite onto disc.

HTH

rob

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Rob Henderson

Expertise

I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions. I also have expierence in application design for all the Office components (Excel, Outlook, etc).

©2012 About.com, a part of The New York Times Company. All rights reserved.