Assistance with CRM built on MS Access and running on Win Server 2016 via MS SQL
Good day.
I would like to inquire if someone can help us understand the operation of the CRM program "Client Accounting"?
The program is built on MS Access, we work with it through Windows Server 2016 locally over the network or by connecting remotely via RDP. The database operates using MS SQL.
Since I am not a specialist in this matter, I apologize if I may name or describe something incorrectly ))
The essence of the problem is... Once our CRM worked on server 2008 and 2012, probably the SQL itself was of a later version. After server 2008 stopped being supported, we switched to 2012 - everything worked quickly on both versions. But last year, due to a server breach, we restored everything and decided to switch to Server 2016 right away, and after that, the program started to lag terribly when working in it via RDP and noticeably lag even during local work in the office just over the network.
The thing is, the developer is Russian, and now we do not want to resolve this issue with their technical support.
And it is unclear what the cause is here, maybe the server (or some network restrictions, or maybe security parameters, etc.), maybe the MS SQL DBMS, maybe somehow the program itself (but I think this is less likely)...
Perhaps it is necessary to monitor some parameters of the DBMS and see what time is being spent and where these delays are occurring.
We tried to reduce the database by deleting information by 50-70% - this did not affect the speed of operation at all.
Our specialists, represented by a system administrator-programmer and an acquaintance in servers, unfortunately cannot overcome this.
If the cost does not suit you, please write your price, we will consider it.
Applications 1
Client's review of cooperation with freelancer
Assistance with CRM built on MS Access and running on Win Server 2016 via MS SQLEverything is fast and professional! I recommend working.
Freelancer's review of cooperation with Oleksandr Minakov
Assistance with CRM built on MS Access and running on Win Server 2016 via MS SQLPromptly provided access to the server for work and answered questions.
Great client.
I recommend for collaboration.
![]()
Current freelance projects in the category Software & Server Configuration
It is necessary to find the cause of periodic freezes of the Linux/PHP server of the online store.Looking for an experienced Linux System Administrator / DevOps to diagnose the causes of periodic crashes of the online store. It is necessary not to temporarily eliminate the symptoms, but to find the root cause of the problem, explain it, and propose an optimal solution.What… Linux & Unix, Software & Server Configuration ∙ 11 hours 16 minutes back ∙ 22 proposals |
We are looking for a specialist/integrator for fiscal systems and platforms for an online store.Description: Greetings! I am looking for a specialist/integrator for fiscalization systems and platforms for an online store. I have opened an individual entrepreneur (IE), have a digital signature key and an IBAN account. There are no other accounts (in Checkbox, platform… System & Network Administration, Software & Server Configuration ∙ 17 hours 32 minutes back ∙ 12 proposals |
Install Office on MacI need help installing Word, Excel, and PowerPoint on a Mac. I'm looking for a specialist who can help me do this remotely, System & Network Administration, Software & Server Configuration ∙ 2 days 10 hours back ∙ 11 proposals |
Need a system administrator
170 USD
We need an outsourced System Administrator. Responsibilities: • Configuration and support of the 1C server; • Migration of 1C (BAS) from a file system to a client-server (SQL); • Technical maintenance of office equipment and internet connections: - 2 printers - 1 scanner - 4-6… System & Network Administration, Software & Server Configuration ∙ 5 days 17 hours back ∙ 17 proposals |
Diagnosis and elimination of recurring WhatsApp Business blocksTask Description A specialist is required with experience in WhatsApp Business and Meta Business to analyze and resolve the reasons for the constant blocking of the WhatsApp Business account. Problem: When logging into the WhatsApp Business account, it is almost immediately… Cybersecurity & Data Protection, Software & Server Configuration ∙ 9 days 12 hours back ∙ 5 proposals |