Is there an app for Ubuntu 13.10 that will allow Me to use a MS Access database? I do not want to convert it because some of the machines on this network are still running Windows. So I need to be able to access the Access file, edit it, use it and save it in native MS Access format from My Ubuntu machine. I am not familiar with the apps available.
2
-
Try Kexi. Take a look here askubuntu.com/questions/303218/…– MitchFeb 1, 2014 at 9:00
-
With current versions of Ubuntu you can use LibreOffice Base as described in this answer.– Gord ThompsonMar 14, 2021 at 14:58
Add a comment
|
2 Answers
Take a look at this StackOverflow post. You'll find some interesting suggestions to your problem. Namely, you have the following options
- Use some proprietary ODBC driver
- Use a programming language specific library like jackcess (java) or MDB Tools (C) - Both are open source
- Use Crossover Office (optimized but not free) or install through Wine (free - assuming you have a valid license for office)
- Create a web user interface for your application and connect it to access via ASP/PHP/etc
For more details and links to the specific solutions follow the abovementioned link.
Also you may find it worthwhile to have a look at Kexi. AFAIK it has some limited .mdb tools.
For this scenario Playonlinux comes to my mind. Visit http://www.playonlinux.com/en. This application will allow you to install MS Access 200X on your machine. -- Regards.
