How to Use Remote database

[shanew]

Hi,

We are using a MS Access Database to update the timings of upload request.

The DB is located in Newyork. we are accessing from India.
I copied the DB to my desktop and started working on it but the problem is the DB is very slow. And its taking around half an hour to open the DB. And i am trying to update the timing in DB, it's taking too much time to update.

Is there any solution for this. And its very hard to work on DB.

please give your suggestions

Thanks

[ExlGuru]

Get some information from this site:

http://blog.tmcnet.com/blog/tom-keat...lem-solved.asp

[ExlGuru]

Here is what you need to do if you have the same issue:

- Run a command prompt (cmd.exe) as an Administrator
- Type: netsh interface tcp set global autotuninglevel=disabled

If you want to to re-enable it:
- Type: netsh interface tcp set global autotuninglevel=normal

In some cases you may need to use this command in addition to the above, but I didn't have to:
- Type: netsh interface tcp set global rss=disabled