MS Access ODBC Connection to Online SQL Server Lagging Issue

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.


Навыки: Microsoft Access, SQL-сервер Microsoft, T-SQL (Transact Structures Query Language)

Показать больше: connection string sql server pivot table vbscript, access applicaties converteren exe sql server, access odbc mysql sends sql statements, connection string sql server asp, odbc connection string iseries server vba excel, access 2007 can log sql server help pdf, html ado connection string sql server, ms access odbc php insert, online sql server tutor jobs, windows mobile online sql server sample, access 2007 dao ado sql server, access 2007 front end sql server 2008, access 2007 ado example sql server, ms access odbc connection to sql server, excel odbc connection to sql server, using ms access as frontend for sql server, how to link ms access database table to sql server, ms access vba odbc connection to sql server

О работодателе:
( 5 отзыв(-а, -ов) ) Port Moresby, Papua New Guinea

ID проекта: #28270160

10 фрилансеров(-а) готовы выполнить эту работу в среднем за $190


We have successfully finished over 520 projects in last 20 years. ID : 28270160 Больше

$250 USD за 7 дней(-я)
(226 отзывов(-а))

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 Больше

$220 USD за 5 дней(-я)
(20 отзывов(-а))

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 Больше

$200 USD за 1 день
(9 отзывов(-а))

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 Больше

$140 USD за 7 дней(-я)
(2 отзывов(-а))

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 Больше

$150 USD за 1 день
(2 отзывов(-а))

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 Больше

$200 USD за 7 дней(-я)
(5 отзывов(-а))

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...

$250 USD за 7 дней(-я)
(1 отзыв)

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 Больше

$111 USD за 2 дней(-я)
(0 отзывов(-а))

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 Больше

$178 USD за 14 дней(-я)
(0 отзывов(-а))

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 Больше

$200 USD за 3 дней(-я)
(0 отзывов(-а))