|
| 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
March 17th, 2009, 03:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
March 17th, 2009, 05:26 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
March 17th, 2009, 05:27 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
March 17th, 2009, 07:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
