glamiop.blogg.se - Openoffice base vs ms access

This means where a feature of the standard is supported, e.g. The HSQLDB 1.8.0 documentation on SourceForge states the following regarding SQL conformance: HSQLDB 1.8.0 supports the dialect of SQL defined by SQL standards 92. Using OOo's Base feature requires installing the Java 2.0 Runtime Engine (which is not open-source) or the presence of an alternative open-source engine, such as Kaffe. OOo 2.0's default (embedded) database is HSQLDB 1.8.0.1, an open-source (BSD license) Java database engine based on Thomas Mueller's original Hypersonic SQL Project. When the Office 12 Beta 1 version becomes available, I'll change from Access 2003 to Access 12 and update previous comparisons where necessary. However, the term "Access clone" is a stretch-to be charitable. Several reviewers have called OOo Base an " Access clone." Some OOo Base windows and most of the wizards I tried resemble those in Access 2000 or later. Part 4 - Multi-Table Reports and Subreports (if possible).Part 3 - Multi-Table Data-Entry Forms and Subforms.Part 2 - Table Design, Datasheet Data Entry, and Data Import/Export.

Part 1 - Database Access, Queries and Simple Reports (this post).

This post is the first of what might end up as four parts: (The previous 10 editions are: Access 1.0, 1.1, 2.0, 95, 97 (3 editions), 2000, 2002, and 2003.) Obviously, I'm interested to learn what potential effect OOo 2.0/SO 8's upgraded database (Base) feature might have on the sales of Office 12 SKUs that include Access 12 and, thus, the future success of Access books.

I'm about to start on the 11th edition of my 1,500-pp Special Edition Using Microsoft Access tome for QUE Publishing, which now has close to one million English copies in print. If not, OOo 2.0-and StarOffice (SO) 8-would be doomed to the purgatory of Office-also-rans, and the Commonwealth of Massachusetts probably wouldn't have mandated the OASIS Open Document 1.0 format that only OOo 2.0 and SO 8 support (so far). I assume that OOo Writer, Calc, and Impress 2.0 have features that satisfy the majority-or at least a significant percentage-of Word, Excel and PowerPoint users, and can open and save documents in current Microsoft Office native formats: *.doc, *.xls, and *.ppt. I use Excel less often and PowerPoint only occasionally. The Google-Sun Microsystems non-event I discussed earlier this month had one significant side-effect: I decided to download and test-drive the current release candidate (RC2) of OpenOffice (OOo) 2.0.Īlthough I spend a substantial part of my working days in Word 2003, I don't consider myself a Word expert.