This is a strange one. I will need to explain the network configuration before explaining the issue.

Network Config:

My companies network has three T1's, and several satelite offices. In our main building there's no issue. The issue is at the satelite offices. The T1's are configured in the following manner: Internet, Data, and the third is shared between the field offices each getting a 512 pipeline. We have a Cisco 2620 Router configured for 512 pipe.

Issue:

We have several MS Access databases that the field offices access and they are getting very poor communication. Everything else (Internet, browsing the network, etc..) is lightning fast. Once you access the data, speed improves, but th initial connection to data is vey slow. Inthe main office a form that opens in say 5 seconds can take over 5 minutes to open in the field office.

Database Config:

The MS Access databases are 2000 and configured client server or 2 tier in design. They are mdb and not adp. There's a mdb that is local to the workstation and a data side that resides on one of our servers. I am going to try adp with MS Access as the data side to see if this will help. These databases are going to be migrated to MS SQL Server but that will not happen for six months or longer. The other solution that I am going to try is to use VB 6 as the GUI to connect to the MS Access database. Both these databases are already over MS Access level for data, they are 40 Meg and 150 Meg in sizes. Both can have three or more users at any given time. Both run without any performance issues in our main building where the servers reside.

If any of you need more information let me know and I will get it posted. First time that I have had this particular issue. I did run a test with VB on a 256K pipe and it ran great. But that was using the VB standard data object. Using a data environment (designer) it had the same performance as the MS Access database does.

Appreciate any help or insight that is offered.