MS Access to MS SQL upload

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

CFausch

Thread Starter
Joined
Mar 3, 2010
Messages
2
We have a local database to gather data on various machines in the company. We have a direct SQL link to the MS SQL server on our local machines, but we can't carry around laptops all day while going form machine to machine due to space and battery constraints, so the local version of the database runs on each machine from a flash drive and is later uploaded to the SQL server.

The issue comes in when the uploads are done from offsite locations to the SQL server. We have a fairly wide pipe to our data center (you can get a 10-15 mb file in a couple seconds more often than not. When uploading from the local Access DB to the SQL server in the data center (on a gigabit link), the appending of new data takes about 5 minutes, and checking existing data against the data in the database takes about 7.5-8 minutes.

When offsite, at the same locations that can move 10+mbps, the appends take 30-45 minutes and the cross-check takes 1-1.5 hours. What is it about access/MSSQL that causes this throttling issue on an otherwise wide enough pipe?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top