 | |
#1
 
| |||
| |||
|
Basic Network Setup -
06-09-2011
, 11:12 AM
#2
| |||
| |||
|
|
Can anyone advise on the best way to network an access database. Currently have two computers connected by LAN cables to a broadband router. Main machine has backend and the other connects over the network. Can be horrendously slow. |
the application. If so the problem is LDB locking which a persistent
recordset connection or an always open bound form corrects (multiple
users)
For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
Quote:
|
Ideally would like 3 workstations, ability to connect to the internet, better speed and remote access from home? |
Remote access from home is a lot trickier. You have basically two
options.
1) Upsize your database to SQL Server. SQL Server Express can be
installed on a workstation and is free.
2) Setup a PC for remote access via the RDP protocol/port. This will
require, among other things, opening a port in your firewall and
directing traffic to a specific PC. If only after hours then an
already existing PC could be used. If you do use this option make
sure you use a pass phrase. A password of at least 12 or 16
characters.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
#3
| |||
| |||
|
|
Can anyone advise on the best way to network an access database. Currently have two computers connected by LAN cables to a broadband router. *Main machine has backend and the other connects over the network. *Can be horrendously slow. Ideally would like 3 workstations, ability to connect to the internet, better speed and remote access from home? |
edits, maybe the Sync Framework can be used to keep the backend
synch'ed slowly in the background. Perhaps look at:
Sync101 with Simple Providers
http://code.msdn.microsoft.com/Sync1...imple-49ee80b4
The only sample is in C#, but it might not be that bad to convert it
to VB.NET?
James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
#4
| |||
| |||
|
|
On Jun 9, 12:12*pm, BobbyDazzler <david.a.mitch... (AT) inbox (DOT) com> wrote: Can anyone advise on the best way to network an access database. Currently have two computers connected by LAN cables to a broadband router. *Main machine has backend and the other connects over the network. *Can be horrendously slow. Ideally would like 3 workstations, ability to connect to the internet, better speed and remote access from home? This is a shot in the dark. If you don't need immediate access to edits, maybe the Sync Framework can be used to keep the backend synch'ed slowly in the background. Perhaps look at: Sync101 with Simple Providers http://code.msdn.microsoft.com/Sync1...imple-49ee80b4 The only sample is in C#, but it might not be that bad to convert it to VB.NET? |
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
#5
| |||
| |||
|
|
On Fri, 10 Jun 2011 11:26:42 -0700 (PDT), "James A. Fortune" CDMAPos... (AT) FortuneJames (DOT) com> wrote: On Jun 9, 12:12*pm, BobbyDazzler <david.a.mitch... (AT) inbox (DOT) com> wrote: Can anyone advise on the best way to network an access database. Currently have two computers connected by LAN cables to a broadband router. *Main machine has backend and the other connects over the network. *Can be horrendously slow. Ideally would like 3 workstations, ability to connect to the internet, better speed and remote access from home? This is a shot in the dark. *If you don't need immediate access to edits, maybe the Sync Framework can be used to keep the backend synch'ed slowly in the background. *Perhaps look at: Sync101 with Simple Providers http://code.msdn.microsoft.com/Sync1...imple-49ee80b4 The only sample is in C#, but it might not be that bad to convert it to VB.NET? This works with MS Access database backends? * |
http://msdn.microsoft.com/en-us/sync/bb821992
"Developers can build synchronization ecosystems that integrate any
application, any data from any store using any protocol over any
network."
I based what I said on that statement rather than from actual
experience, so I hope that it's true for Access as well.
James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
#6
| |||
| |||
|
|
2) Setup a PC for remote access via the RDP protocol/port. This will require, among other things, opening a port in your firewall and directing traffic to a specific PC. If only after hours then an already existing PC could be used. If you do use this option make sure you use a pass phrase. A password of at least 12 or 16 characters. |
LogMeIn.com or GoToMyPC. I use LogMeIn with clients (the free
service) and it works fine. I wouldn't want to work with it, but it
won't be any different with raw Windows RDP access (which is what
all these remote access services use under the hood -- the only
value they add is the bypassing of the step of setting up your
router to forward ports).
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#7
| |||
| |||
|
|
2) Setup a PC for remote access via the RDP protocol/port. This will require, among other things, opening a port in your firewall and directing traffic to a specific PC. If only after hours then an already existing PC could be used. If you do use this option make sure you use a pass phrase. A password of at least 12 or 16 characters. Well, that is, if you don't want to use a 3rd-party service like LogMeIn.com or GoToMyPC. I use LogMeIn with clients (the free service) and it works fine. I wouldn't want to work with it, but it won't be any different with raw Windows RDP access (which is what all these remote access services use under the hood -- the only value they add is the bypassing of the step of setting up your router to forward ports). |
them.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.