A couple of weeks ago I was hired to clean up and edit a membership database for an organization that a friend of mine belongs to. He's the org's treasurer and keeps a membership list that was created via Microsoft Access.
The thing is, he only has OpenOffice Access, which I recommended to him because I use OpenOffice Writer and sometimes its Calc as well. These two programs are fully cross-compatible with Microsoft Word and Excel and can save in those formats.
The problem is that OpenOffice Database is NOT completely compatible with MS Access. Files created in MS Access and saved in .mdb format are strictly write-protected and read-only when opened in OpenOffice Database.
Is there any way to change the format of the file or otherwise render it writable in Open Office?
If absolute worst came to absolute worst, I have a copy of the file, now, myself, and can use it to create a new OpenOffice database file from scratch. But before I resort to such a step I'd like to get some info over here.