I am updating the Migration Guide files (part of OOoAuthors.org) for OOo2.0 (based on 1.9.74) so that the updated guide is ready for the regional conferences. One of the chapters of the guide is titled Sharing Files. I would just like to check that my understanding on a few matters on sharing Microsoft Access files is correct.
* On Windows based machines OOo can access Microsoft Access (.mdb) files via ADO. This gives full read/write access, but there is a problem in that file locking does not occur, so concurrent updating is a potential problem. * On Windows machines you can also connect via ODBC. ODBC has the additional problem of not handling automatically incrementing fields. * On Linux machines it is possible to connect via an experimental ODBC driver, which at this stage is read only and has a limited subset of SQL queries. * It is possible to convert .mdb files to another format such as mySQL via 3rd party converters, but these converters only convert the table data and not things like the relationships between the tables. * There is no way for OOo to import forms and reports from Microsoft Access. And some more questions: Is there a way of importing .mdb files into HSQLDB, so that the data is embedded in the OOo Base (.odb)? Is there some other way of sharing files between Microsoft Access and OOo that should be included? Are there other issues that people should be made aware of? I am a strong advocate of OOo. The above is not intended as a criticism but as a check that my understanding, based on searches of the web, is correct. Thanks, Ian Laurenson --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
