MS Access ODBC Connection to Online SQL Server Lagging Issue

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

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

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

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.

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

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.

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