I have installed Libre on an old windows laptop and on my Mac. I want to transfer database files from the windows version to my Mac copy of Libre. Firstly, I imported Access database file into the version of Libreoffice Base and the new Base file how has the extension .mdb. I emailed myself the file called medals.mdb, hoping to be able to open it in Libreoffice/Base on my Mac. I dowlonaded the file medals.mdb from the incoming email to my desktop, opened Libreoffice and tried to open the file, but get the error message: The connection to the data source “medals” could not be established. connection for the following URL was requested “/Users/joanmurray/Desktop/Access Files/Pete/Stock lists/Medals.mdb”. Now, this is the location of the original Access file on my old computer. How do I break the connection with Access and newly created Base file so that I can mail it and share it on another (Mac) machine?
I am using OSX 10.9 on my mac and the 2002 version of Access on the windows computer.
Now, I am not a very technical person, wondering if I am missing something very simple to get over this. Is there a step I need to take on the windows version of Libre before I can share the file and open it on another machine. I actually want to move all my old access databases to Base and get rid of access altogether. Would very much appreciate suggestions. Thanks.