| View previous topic :: View next topic |
| Author |
Message |
cska_27
Newbie
Joined: 28 Nov 2004
Posts: 1
|
 Posted: Sun Nov 28, 2004 10:05 am Post subject: Is OOo compatible with Microsoft Access' .mdb files |
 |
|
Hi,
I've just discovered OpenOffice.org. It looks really spectacular. I know that Writer and CALC are compatible with their respective MS Office counterparts of Word and Excel, but as an accountant, I also work a lot with Microsoft's Access, and sometimes work at home. What I wish to know is if OpenOffice.org is compatible with Access, as it is imperative for me to be able to use a database from both work and home. (At my workplace, there is only MS Office)
Thanks! |
|
| Back to top |
|
 |
8daysaweek.co.uk
Super User
Joined: 29 Nov 2003
Posts: 2130
Location: UK
|
| Posted: Sun Nov 28, 2004 10:12 am Post subject: |
|
|
cska_27,
| cska_27 wrote: | | What I wish to know is if OpenOffice.org is compatible with Access |
No it isn't in the sense that you can't open .mdb files using OOo  . You can however connect to MS Access tables using OOo and create your own queries, forms and reports in OpenOffice.org.
However... in v2.0 (expected next year) there will be more changes to the OOo dB functionality:
http://dba.openoffice.org/miscellaneous/dba20.html#base20
BFN,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site |
|
| Back to top |
|
|
José Josephs
General User
Joined: 31 Aug 2004
Posts: 21
|
| Posted: Fri Dec 10, 2004 8:54 am Post subject: OO Database vs Access |
|
|
| The OO Database for Windows opens and sorts dbf files just fine. Access and Excel both have dbf outputs. _HOWEVER_ it doesn't do the same on Linux versions! The OO database will open dbf files, but won't index (sort) them with a one-click on the column name. This is a big disappointment on the Linux version. If you're a Linux user, it means having to maintain a Windows box to do this task. |
|
| Back to top |
|
|
|
