MS Access ODBC Connection to Online SQL Server Lagging Issue -- 2

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.

Cheers,

Microsoft Access Microsoft SQL Server T-SQL (Transact Structures Query Language)

Identifikační číslo projektu: #28391339

O projektu