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 фрилансеров(-а) готовы выполнить эту работу в среднем за $190
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...