I have a database with MS Access as front end and SQL Server (Express 2014) as the back end.
Just recently, I restored the backend to hostgator (for online hosting) and connected the front end via ODBC connection.
It works perfectly but it becomes terribly slow due to latency and other WAN related issues.
Currently, all the codes and queries are being fired out from the front end (MS Access). The SQL Server only contains tables.
I’m reaching out to any developer who can help to resolve this issue. He/she must be proficient in:
1. MS Access VBA
2. MS SQL Server and
3. Importantly, he/she must have previous experience in working with Hosting SQL Server online
Here are some implementation agendas:
1. Creating Stored Procedures
2. Creating pass through queries
3. Implement other best practices
Upon completion, the front end must connect successfully to the online sql server at hostgator with not lagging or other issues whatsoever.
If you know you are the right candidate, please outline your strategies as to how you are going to tackle this project in your application.
10 freelances font une offre moyenne de 190 $ pour ce travail
Hi, Greetings! ✅checked your project details: MS Access ODBC Connection to Online SQL Server Lagging Issue ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experien Plus
Hi ! When viewing your job details, it really jumped out at me. In my current Professional Microsoft SQL Server DBA role, I have extensive experience with Resolving SQL Server performance when perform tasks and action Plus
Sir , I'm a professional .NET developer with a wide experience in SQL Server ( SPs , Triggers , views , ... ) and MS ACCESS as well , actually I've been exactly through projects just like yours a lot of times before to Plus
Hello there ! I would like to take a look at your prod SQL Server performance numbers to find out the the actual root cause of performance problems. I can optimise your database if required; I can't fix latency probl Plus
Hi I am very interested in your project and would like to know more. For background, I am a full-time, freelance developer with over 25 years experience of building bespoke solutions. I am now based in Germany but sp Plus
Hi! I have extensive experience in MSSQL / ACCESS / VBA Recently completed a similar project where I moved all the logic from VBA to TSQL. I will solve the problem quickly and efficiently. Let's discuss details...
Hello Sir, Wrishav here with 7+ years of experience in SQL, Azure, MS Access and other technology. I have gone through the issue you are facing and I can fix the issue for you. I would require sysadmin access in datab Plus
We are a new venture consisting of database and website developers. Although we have years of field experience, we are still new to concept of freelancing. However, you must be rest assured that we are capable of provi Plus
Hi my name is Shafik and i a developer with more than 15 years experience in Microsoft technologies. have more than 7 years experience in MS Access / MS SQL. in the last 4 years i worked on ms access projects with ms Plus