Recent content by amorosik

  1. amorosik

    Is AI the end off all forums?

    I think this (AI new era) will be the start of some AI forums
  2. amorosik

    Improve FE - BE performaces on LAN

    "..Shifting to SQL Server is like climbing mount Everest.." "..if you really want performance forget about that SQL server its just a story for kids.." "..MYSQL in terms of performance it will always be superior.." It doesn't seem like you've had good experiences with Sql Server, which I...
  3. amorosik

    Automatically Refresh a form when table data changes externally, table macro perhaps?

    In reality it is not necessary to update a grid with the current recordset In fact it is harmful because the operator could be in the middle of a modification What I would do is simply 'display' the incoming call or in any case the change of state in the telephone pbx Then it will be the...
  4. amorosik

    What prevents Access from using the full power of the PC?

    When I wrote ".. over ten minutes.." I meant for a project with: - 650 forms (the largest one 1,700 Mbyte, another ten over 400 Kbyte) - 110 modules (the largest one 900 Kbyte, others 400 Kbyte..) - 120 queries - 300 reports - 512 linked data tables - 2 internal data tables So I'd say we're...
  5. amorosik

    What prevents Access from using the full power of the PC?

    It takes about a minute for a project of how many forms/reports/modules?
  6. amorosik

    What prevents Access from using the full power of the PC?

    Yes, compacted and compiled
  7. amorosik

    What prevents Access from using the full power of the PC?

    https://github.com/msaccess-vcs-integration/msaccess-vcs-integration
  8. amorosik

    What prevents Access from using the full power of the PC?

    Your hypothesis seems incorrect to me If the Access code is executed only mono-core then why do we see several active and working cores? What we see in the graph is only the activity of Microsoft Access because before starting I checked if everything was at zero or almost and the CPU commitment...
  9. amorosik

    What prevents Access from using the full power of the PC?

    Sometimes it happens that an Access procedure is busy for a long time For example, when I export a project of hundreds of forms and reports, using the Vcs procedures, the sequence of operations lasts over ten minutes I'm talking about code that is executed and databases locally, and therefore...
  10. amorosik

    How to read the Funct/Sub name from Vba code?

    Yes I know MzTools and the possibility of using its functions to create the start and end routines I wanted to understand if it was possible to do it only from Vba code And it seems not to be possible
  11. amorosik

    How to read the Funct/Sub name from Vba code?

    In order to implement effective error handling, it would be useful if from code you could read the name of the sub/function inside which the code is running A sort of Me.name for forms Then the question is: how to read, via vba, the name of the function/sub inside which the code is running?
  12. amorosik

    Monaco Sql editor - exactly why we should use it ?

    One of the most important features in the new version of Access is the Sql editor Monaco I tried to use it, but I can't fully appreciate the improvements made For those who have already had the opportunity to use it, I would like to ask: exactly, why use the new Sql editor?
  13. amorosik

    Emmanuel Katto Dubai : Question About Running ACCDE Database in ACCDR (Access Runtime)

    ??? To run an access file with the .accde extension, simply install the Access runtime
  14. amorosik

    Unable to create .accde

    How many data tables is the program connected to? It seems to me that the limit for Access 2013 is 2048 tables OPEN AT THE SAME TIME But simply for the connection, it does not seem to me that there is a limit imposed by the programming environment
  15. amorosik

    Replacement for Outlook

    I currently use Thunderbird, and it has been my local email and news client for over 10 years Outlook is definitely more powerful and has better features But where possible, I always prefer open source programs
Back
Top Bottom