We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Converting MS Access Database To Open Office 'Base'

Options
2»

Comments

  • S0litaire
    S0litaire Posts: 3,535 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    Don't go for Open Office!!

    Go for Libre Office instead http://www.libreoffice.org

    It's a bit more functional than Openoffice
    Laters

    Sol

    "Have you found the secrets of the universe? Asked Zebade "I'm sure I left them here somewhere"
  • johnmc
    johnmc Posts: 1,265 Forumite
    Are you wanting to use a database which has been written by someone else?

    If so, you just need the Access runtime which is free from MS;
    http://www.microsoft.com/en-us/download/details.aspx?id=4438

    Access uses VBA whereas Open and Libre use Java and OpenOfficeBasic, which are not totally compatible.

    Although simple databases can be transferred over anything using VBA functions will probably not.
  • macman
    macman Posts: 53,129 Forumite
    Part of the Furniture 10,000 Posts Name Dropper
    I'm just converting it for someone else, as they no longer have access to Access.
    AFAIK only the basic functions are required, in which case Base (be it in Open Office or Libre Office) may well do the job.
    No free lunch, and no free laptop ;)
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.8K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.2K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.