Find Jobs
Hire Freelancers

MS Access ODBC Connection to Online SQL Server Lagging Issue

$30-250 USD

Closed
Posted over 3 years ago

$30-250 USD

Paid on delivery
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,
Project ID: 28270160

About the project

10 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $190 USD for this job
User Avatar
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 experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$220 USD in 5 days
5.0 (20 reviews)
6.0
6.0
User Avatar
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 integrate between Access and SQL with / without ODBC , most of it was on local Servers , but any way I check it out and of course you won't pay anything unless you'll be sure i can do it , lets talk about details so I can investigate more about your project
$140 USD in 7 days
5.0 (2 reviews)
2.6
2.6
User Avatar
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 problem or any problems with your front end MS Access code. I've exceptional knowledge and experience in Database Development & Administration (5+ years); with Microsoft SQL Server (versions 2008-2019). Warm regards, Kundan
$150 USD in 1 day
5.0 (2 reviews)
2.3
2.3
User Avatar
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 spent all my working life up until recently in the UK. I am proficient in Visual Basic in all its flavours (VB6, VBA, VB .NET) and work with clients in a variety of countries. I use LogMeIn Rescue and Teamviewer to interact remotely with my clients both for installation/bug fixing and for training. I am available on Sk ype as well as normal telephones. I am also competent in SQL Server, SQL Server Reporting Services and Crystal Reports. The main problem that you face is that ACCESS can be really slow in this situation. First off I would eliminate the ODBC connections and use ADO instead. This is faster and more reliable. I would also set up stored procedures on your SQL server so as to reduce the amount of data being passed down to your code. Many of these stored procedures could have parameters attached where necessary. There are other steps that could be tried to speed up your connection. I am sure that the overall speed could be improved by this path I hope to hear from you.
$200 USD in 7 days
5.0 (5 reviews)
2.1
2.1
User Avatar
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 in 7 days
5.0 (1 review)
1.7
1.7
User Avatar
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 database along with MS access. I am keeping the charges as nominal as I am very new to this platform but I will make sure you will be happy to rate me highest after the job completion. Please feel free to reach out to me in +91-7207687814 (WhatsApp) for any help for the same. Best Regards, Wrishav
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 providing best services with complete transparency and professionalism. We will be assisting you 24/7 via Skype and WhatsApp.
$178 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 sql 2014 - complex db with more than 400 objects in the db. able to deal with complex ms sql queries,stored procedures,functions and views. In addition my job include importing data from excel/text to sql. make manipulation on the data : sort - calculating - formatting and so. build complex reports. precision in work. Ability to deal with exist code. Thank you for your time and consideration. Sincerely, shafik
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PAPUA NEW GUINEA
Port Moresby, Papua New Guinea
5.0
5
Payment method verified
Member since Mar 6, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.