I have a database which I started from MS Access in MS Office '97, butwhen I email it to my Linux Ubuntu machine, I can open it withOpenOffice Base but it isn't recognizing any of the data fields or thedata which I put into the Access file. Is Ubuntu Base compatible withMS Access?
I have found it so - perhaps some fields in your database have fieldproperties and data types not recognised by OO-Base. I have used MSOffice97 and transferred all [i.e. powerpoint, word, access, excel] to OO.
I forgot to mention... i converted from access to OO on windows machinetransferring to a usb disk drive fat32. Then read the files with linuxrunning OO. Perhaps that made a difference. I can't think that the fileformat should affect it?
Well at least that work for you. If you save the data tables as MS office XXXXyear it should transfer with ease. Unless you have tables that link up for dataon the network server. OO may be looking for the links and cannot.
Could I upload the Access database file here to see if anyone canbring it up thru Ubuntu? It's just a draft file so I'm not worriedabout any sensitive or private info getting passed around.I want to work with the file on either the Windoze box or the Linuxbox, and as Ubuntu won't recognize my floppy drive (not a bigproblem), I will just toss the updated file back and forth via emailto work with my updates as I progress on the data.
Actually, I think I found a better answer.I exported the data into HTML and imported it into an Excelspreadsheet. This part worked OK. So I'm thinking the data will workbetter as a spreadsheet rather than as a database anyway. I'll see ifUbuntu OpenOffice can work with it as a spreadsheet.
I'll have a look at it if you like. Thought's just occurred regardingyour floppy drive... is it 6.10 you're using - i had the same problem.Another thought - if you have a googlemail account you could use theironline app and check it there... i only used it for a word file but itworks for all the MS office apps.