Link to home
Start Free TrialLog in
Avatar of NVIT
NVITFlag for United States of America

asked on

Convert MS Access Forms to OpenOffice OpenBase

Is there a built-in way to do this?
If not, are there 3rd party programs to do this?
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NVIT

ASKER

Thanks, Jeffrey. I asked because I have existing Access 2000 .mdb files, which include databases, forms, queries.

Opening the .mdb file in OpenBase reads the databases. But, the forms and queries don't seem to show.
Avatar of NVIT

ASKER

If OpenOffice can't do it... is there a non-MS commercial program that can read (and convert I guess) the databases, forms, queries
As from what I've seen, it's a complete rewrite. OpenBase is quite different from Access.

/gustav
>>>  is there a non-MS commercial program that can read (and convert I guess) the databases, forms, queries

Just seconding Jeff's comment.  The forms, queries, reports and code are specific to the MS Access platform, and will have to be redone.  Even porting an Access solution to another MS platform such as Visual Studio will involve a major rewrite.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<<Make sure you want to go down the path of OpenOffice before diving in head first.>>

+1

Really dig into Open Office to get a feel for the effort and feasibility of developing solutions as robust as your Access databases.

I had one client ask me to develop a few Open Office database solutions.  He ultimately had me rewrite a couple of the more complex solutions in Access.  That was a few years ago and things may have changed, but Open Office at that  time did not have the same capabilities as Access.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial