Recent content by Etxezarreta

  1. Etxezarreta

    Solved Possible to use a huge Firebase db?

    We manage to deal with these files: we upload them into a MySql in a remote server, then we used pass-through queries from an Access, the queries are then used by Excel through Powerquery. Thanks for your help you all.
  2. Etxezarreta

    Solved Possible to use a huge Firebase db?

    Hi Doc, I will try to figure this out, many thanks
  3. Etxezarreta

    Solved Possible to use a huge Firebase db?

    The data also come as CSV. We will try to import into a MySql, I keep you updated
  4. Etxezarreta

    Solved Possible to use a huge Firebase db?

    Whereas I said it quit, I managed to connect actually. It is when I try to sum up values that it chokes
  5. Etxezarreta

    Solved Possible to use a huge Firebase db?

    Here is the link to the table: https://www.insee.fr/fr/statistiques/fichier/5395740/RP2018_indreg_dbf.zip I create a linked table, and then when I try the query below: SELECT FD_INDREG_2018.DEPT, Sum(FD_INDREG_2018.IPONDI) AS SommeDeIPONDI FROM FD_INDREG_2018 GROUP BY FD_INDREG_2018.DEPT...
  6. Etxezarreta

    Solved Possible to use a huge Firebase db?

    Access quits actually
  7. Etxezarreta

    Solved Possible to use a huge Firebase db?

    Sorry for the word operate: I meant, just using the data from that DBase with Access or Powerpivot. Many thanks.
  8. Etxezarreta

    Solved Possible to use a huge Firebase db?

    Hello all, One client asks me if we could help them operate some Firebase databases: they are huge: I have tried tiding them up to Access or Powerpivot, but it chokes before ending. I guess the queries would be very slow, or even wouldn't ever return results. Some of you people have some...
  9. Etxezarreta

    Googlesheets as a backend?

    Hello, Thanks a lot, Could you give us some details please?
  10. Etxezarreta

    How can I know who hasn't closed the file?

    I keep you updated about the answer!
  11. Etxezarreta

    How can I know who hasn't closed the file?

    It looks promising: as I don't have access to the server for a couple of weeks, I 'd like to run a few trials in my local computer. How should I adapt the following code please? Many thanks! openfiles /Query /s Server /fo csv pause
  12. Etxezarreta

    How can I know who hasn't closed the file?

    Thanks, I think this is for Excel files only, isn't it?
  13. Etxezarreta

    How can I know who hasn't closed the file?

    for instance: .pdf, .dwg, .dsd, and office files
  14. Etxezarreta

    How can I know who hasn't closed the file?

    Hello everyone, I have folders and subfolders that contains different files: pdf, autocads etc.. Before I move one folder, I need to make sure that all the files in the folders are closed, and to know who is the user that hasn't closed his files. Would you have any suggestion please? Many...
Top Bottom