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
|
|||
|
|||
speed things up!!
Hello, I have a front end back end access 2007 database that I have created.
I also have a VPN set up amongst our 3 branches with a forth at our server. Is there a way to speed the interaction between the front and back end up?? I know nothing about the multiuser world and utilizing our internal VPN. It just seems like it takes a long time to load any of the forms and reports. Any suggestions would be great!! thanks in advance Ryan |
#2
|
|||
|
|||
speed things up!!
Access over a WAN is inherently slow. This article tells you why:
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html. It also gives some alternatives for solving the problem. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Ryan" wrote in message ... Hello, I have a front end back end access 2007 database that I have created. I also have a VPN set up amongst our 3 branches with a forth at our server. Is there a way to speed the interaction between the front and back end up?? I know nothing about the multiuser world and utilizing our internal VPN. It just seems like it takes a long time to load any of the forms and reports. Any suggestions would be great!! thanks in advance Ryan |
#3
|
|||
|
|||
speed things up!!
Were are the FEs? They should be on the end user's machines and not out on a
network drive. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Ryan" wrote: Hello, I have a front end back end access 2007 database that I have created. I also have a VPN set up amongst our 3 branches with a forth at our server. Is there a way to speed the interaction between the front and back end up?? I know nothing about the multiuser world and utilizing our internal VPN. It just seems like it takes a long time to load any of the forms and reports. Any suggestions would be great!! thanks in advance Ryan |
#4
|
|||
|
|||
speed things up!!
Hi Jerry,
The FE are on the end user machines and the BE is on our server. "Jerry Whittle" wrote: Were are the FEs? They should be on the end user's machines and not out on a network drive. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Ryan" wrote: Hello, I have a front end back end access 2007 database that I have created. I also have a VPN set up amongst our 3 branches with a forth at our server. Is there a way to speed the interaction between the front and back end up?? I know nothing about the multiuser world and utilizing our internal VPN. It just seems like it takes a long time to load any of the forms and reports. Any suggestions would be great!! thanks in advance Ryan |
Thread Tools | |
Display Modes | |
|
|