If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
database Inputs from WAN???
I apparently fell short on my research when i started this project,, i have
spent all winter working on this Access database that works well on our LAN and i was hoping to either VPN or link some sharedpoint tables to two crews in the field both are painfully slow.. one form takes nearly 15min to load and another 7min to close.. we have what i feel should be a simple task.. we have two teams of 3 people where we need to track Times worked, Miles driven, and Overnight costs, the team leader enters the times so there will only be two users outside the office entering a max of about 10 records a day. and print a report for the days entries. since the .mdb seems to be a failure where should i turn?? I think we have some space with a yahoo website. can we somehow web base something?? any help or direction is desperately needed.. Thanks Barry |
#2
|
|||
|
|||
database Inputs from WAN???
On Wed, 6 May 2009 10:58:01 -0700, Barry A&P
wrote: Have them use Windows Terminal Server to get into a server machine at the office, and they are essentially running a session on that machine and only the screen refreshes travel the wire. That should be fast enough for most connection types. Your IT support person will know how to configure Terminal Services. It ships in the box with any server-class Windows operating system. -Tom. Microsoft Access MVP I apparently fell short on my research when i started this project,, i have spent all winter working on this Access database that works well on our LAN and i was hoping to either VPN or link some sharedpoint tables to two crews in the field both are painfully slow.. one form takes nearly 15min to load and another 7min to close.. we have what i feel should be a simple task.. we have two teams of 3 people where we need to track Times worked, Miles driven, and Overnight costs, the team leader enters the times so there will only be two users outside the office entering a max of about 10 records a day. and print a report for the days entries. since the .mdb seems to be a failure where should i turn?? I think we have some space with a yahoo website. can we somehow web base something?? any help or direction is desperately needed.. Thanks Barry |
#3
|
|||
|
|||
database Inputs from WAN???
Small tables with a few records should work quite well over a wan, even with
a limited connection. This is especially so with SharePoint and access 2007.... any help or direction is desperately needed.. I outline solutions to this problem in the following article: http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
Thread Tools | |
Display Modes | |
|
|