Recent content by Marrafeiro

  1. M

    Runtime access slow opening

    Yes, this is a management software for public and private schools, this software already have almost 15 years and have me and other person who develop new features or correcting bugs everyday. We already put some heavy work in python scripts and t-sql, but ofc to do that for all application is...
  2. M

    Runtime access slow opening

    I already did that. I tested out with the trust location on and with the FE location path. With the trust location on it was sliglty slower than the tests I did with the trust location off.
  3. M

    Runtime access slow opening

    Thank you for your time. I have test the two options. By adding trust location is slightly slower than disable the trust locations with the VBA Warning registry. About giving an access, i must speak with my manager if i can give you a test account.
  4. M

    Runtime access slow opening

    We have 2 host machines using proxmox in the moment for each core we are giving 2.5 vCPUs: Machine 1: 2x Intel Xeon Silver 4110 (32 Cores) and 256GB RAM Machine 2: 2x Intel Xeon E5-2680 v4 (56 Cores) and 256GB RAM The Machine 1 have: Server 1 have SQL Server with 24 vCPUs and 48GB of RAM. The...
  5. M

    Runtime access slow opening

    We have 32gb of ram per virtual server and each virtual server allocate around 30 users. In the old architecture we had a monolitical server with 128gb of ram for around 150 users and it was pretty fast. I disabled the vba warnings in regedit about trust locations too.
  6. M

    Runtime access slow opening

    we have 6 virtual servers with 2 sockets, 32 virtual cpu's and 32GB of ram, normally we have around 30 users per server. Each user use their own frontend. The databases in sql server are diferent too, each user have their own database the biggest one have around 2gb. The files we have the shared...
  7. M

    Runtime access slow opening

    The file can't be moved to the client machine. The Client connect directly to our servers by RDP connection. And Yes the file have 700MB, it is a very big app, i can say it have around 6000 forms,subforms, querys, reports and VBA modules.
  8. M

    Runtime access slow opening

    Hi everyone, I'm going to try explain my problem, my english is not my native language, so i'm sorry if i make any mistake. My company have a software made in access, it have around 700mb of size, is believe is a big app. The data is in an SQL Server, so we have all the tables linked to MS...
Top Bottom