On Mon, 2005-01-31 at 14:46 +1300, Ian Laurenson wrote: > 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.
Does ADO do locking? > > * 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. You mean MDBtools? http://dba.openoffice.org/ and http://mdbtools.sourceforge.net/ THen this small set of SQL commands should be sufficient to move from mdb to a real RDBMS. > > * 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. > THis is true converting from say postgres to mysql as well. Indexing et cetera are usually done after moving the data. > * There is no way for OOo to import forms and reports from Microsoft > Access. > Not until a VBA converter is provided. > > 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] -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
