Hi Alexander & Robert, Thank you both for your responses and suggestions. Sorry about the delayed reply - I've had limited access to the User's Mac.
It is with a rather red face that I report that the problem was caused by me forgetting to load a Library file of 45 functions that I have written which form a central part of the system! The Library file is loaded under My Macros | Standard and is stored with LO files. It is not part of the .odb file. I do it that way because the functions are common to all the databases I have written. When I've forgotten to load the Library other times, (on Windows PCs), I've had an error message when the database has been initializing, telling me it can't find a particular function, and this has alerted me to what the problem is. But the Mac reacted differently, so I assumed that it was a Mac problem. Bad assumption! Sorry I bothered you. However, I did unzip the .odb file as you suggested, and examining the code alerted me to all the calls to the Library functions. So your advice did lead me to the solution. Once the Library file was in place, all the Queries, Forms and Reports magically appeared! Much of the system is now working, but I'm still having problems opening the main menu. I discovered that I have used a few calls to Windows functions, which naturally, the Mac takes a very dim view of! I've tracked down several of these, but I think there must be more. I knew that porting to the Mac would be difficult, but I'm now hopeful that I'll get there in the end. Many thanks for your help Noel -- Noel Lodge lodg...@gmail.com On 15 September 2017 at 16:50, Alexander Thurgood <alex.thurg...@gmail.com> wrote: > Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit : > > Hi Noel, > > I don't know of any particular configuration setting that might cause > this, unless there is something physically wrong with the file itself. > > Some possibilities to explore : > > - if you have automatic document backups (AutoSave) configured on the > Mac LO, turn that off, restart LO and see if it makes a difference. > There is/was a known bug that affected the display of some ODB files > when this option was activated ; > > - compare the files on both OSes to check that they are identical (in > structure and content) by unzipping each one ; > > - when you create a query in H2 via LO, is it stored within the H2 > database schema, for which the LO ODB would merely contain a reference > (with a file path, which would be different between Win/Mac) OR is the > query stored within the LO ODB in full SQL ? > > > The fact that you can't see any of the Queries, Reports, Forms, might > indicate a problem with the paths in the XML sections of the ODB file > that defines each of these. > > > Alex > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
