wood burning stoves*
The moose likes Other Java Products and Servers and the fly likes Access databases and Star Office Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Access databases and Star Office" Watch "Access databases and Star Office" New topic
Author

Access databases and Star Office

John Welsh
Greenhorn

Joined: Jun 20, 2002
Posts: 1
Ok, I know that you can bring in tables from access databases, here's the big question though. The users in our network are really picky about things and would also want their forms for data entry to come over. Is there any way to do this? Also, is there a way to open the Access db without adding an ODBC. These two things are kind of what is stopping us from proceding and purchasing more licenses of this. Any help you can provide would be great!
Solveig Laura Haugland
Author
Ranch Hand

Joined: Oct 24, 2000
Posts: 377
>> Ok, I know that you can bring in tables from access databases, here's the big question though. The users in our network are really picky about things and would also want their forms for data entry to come over. Is there any way to do this? Also, is there a way to open the Access db without adding an ODBC. These two things are kind of what is stopping us from proceding and purchasing more licenses of this. Any help you can provide would be great!
Hi John,
What form are your forms currently in? I'm not sure how you're using the forms; would it work to just keep using those forms, and just suck the data into StarOffice using the data source setup? (StarOffice 6.0 or 5.2? DB stuff is slicker and simpler in 6.0.)
The ODBC-accessible formats in 6.0 are MQIS and Visual Foxpro. Other than that, there's also JDBC, plus Adabas, dBase, ADO, and spreadsheet, text, and address book. Microsoft Access doesn't seem to come up, in the window or in the help.
LMK more; I'll try to figure out what I can.
Thanks,
Solveig


OpenOffice.org Users' Guides, Training, and More www.getopenoffice.org
J2EE: The Big Picture - Dating Design Patterns: What the Gang of Four Didn't Tell You - Dating Power Tools: Simple Stuff That Works - She'll Love It: The Guys' Guide to Giving Great Gifts
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Access databases and Star Office