Convert MS Access 2000 App to OO Base

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Convert MS Access 2000 App to OO Base

Postby dannydont » Thu Feb 26, 2009 7:29 pm

I currently have an Access 2000 Application that I would like to convert to OO Base. If you are knowledgeable about converting a DB from Access 2000 to OO Base, could you share your thoughts. It is easy or is it a nightmare and what is the process (in some detail)? I see that OO Base has an Import Option for Access 2007. Perhaps the best thing to do would be to convert my application to Access 2007 (if I can find someone with Access 2007) and then Import the results into OO Base. Thoughts.
Thank you for any help you might provide.
Dan
dannydont
 
Posts: 10
Joined: Tue Apr 08, 2008 9:18 pm

Re: Convert MS Access 2000 App to OO Base

Postby Villeroy » Thu Feb 26, 2009 8:08 pm

dannydont wrote:I see that OO Base has an Import Option for Access 2007.

:?: What do you mean :?:
You can access Access databases in Base like you can access many 3rd-party databases in Access. You connect to the database engine with some kind of driver (COM, ODBC, JDBC). That's all.
You can not "import" anything but the raw tables. There is no equivalent to MS Access in this office suite. Keep your MSAccess up and running until you converted your database to something more accessible than Access.
Base is not an Access replacement. viewtopic.php?f=13&t=14060&p=66326#p66326
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25371
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Convert MS Access 2000 App to OO Base

Postby dannydont » Fri Feb 27, 2009 2:58 am

Thank you for the feedback. I am not very knowledgeable about OO Base as my question obviously showed. It will take a LOT of effort to rewrite my application in another DB product. I will try the "Connect" and see what happens. I am thinking however that this only gives me the data but not the Forms and Queries and Reports, etc. Thanks again,
Dan
dannydont
 
Posts: 10
Joined: Tue Apr 08, 2008 9:18 pm

Re: Convert MS Access 2000 App to OO Base

Postby Villeroy » Sat Feb 28, 2009 1:57 pm

It will take a LOT of effort to rewrite my application in another DB product.

This is a common attribute of all Microsoft applications and it's intentional. Queries are just SQL-strings you can copy from one database to another and adjust some syntactical differences. However, MS extends the SQL standard with dozends of additional functions, so you may need to do more than copy&paste and find&replace.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25371
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest