Hello all:
I have a networking/database question that I'm hoping I can get some advice on.
Because of limited budget and a paranoid boss, the MS Access database at work is running through a simple Linksys wireless E2000 N router rather than a more dedicated server setup.
A desktop server PC is storing the Access database and 3-4 laptops are connecting to the split database linked tables via laptop wireless N adapters only.
Upon having several people accessing and updating records we've noticed a huge amount of instability frequent network interruptions.
I have several theories/observations but would like anyone's take that may have some insight:
1) While not an ideal location (one end of the building), signal strength is consistently shown as 4/5 bars to 5/5 bars, even through several walls
2) Interference: Several other routers, all on 2.4Ghz could be creating too much interference. (none of the laptops support 5Ghz)
3) Number of individuals accessing the database at one time. This is where I'm unclear. Could having 3-4 people working on the database at once pose any potential problems? I'd ordinarily think not but I am coming up short with explanations.
Last week two of us were working with the database, updating records and such, from probably 100 ft or more away with no issues. Then the last few days just to stay connected requires being within 5-10 feet of the router AT MOST. No settings have been changed and network disconnects/interruptions in Access are happening every few minutes. I'm totally confused and convinced it is router related in some way.
Any ideas or recommended changes?
Thanks in advance!
I have a networking/database question that I'm hoping I can get some advice on.
Because of limited budget and a paranoid boss, the MS Access database at work is running through a simple Linksys wireless E2000 N router rather than a more dedicated server setup.
A desktop server PC is storing the Access database and 3-4 laptops are connecting to the split database linked tables via laptop wireless N adapters only.
Upon having several people accessing and updating records we've noticed a huge amount of instability frequent network interruptions.
I have several theories/observations but would like anyone's take that may have some insight:
1) While not an ideal location (one end of the building), signal strength is consistently shown as 4/5 bars to 5/5 bars, even through several walls
2) Interference: Several other routers, all on 2.4Ghz could be creating too much interference. (none of the laptops support 5Ghz)
3) Number of individuals accessing the database at one time. This is where I'm unclear. Could having 3-4 people working on the database at once pose any potential problems? I'd ordinarily think not but I am coming up short with explanations.
Last week two of us were working with the database, updating records and such, from probably 100 ft or more away with no issues. Then the last few days just to stay connected requires being within 5-10 feet of the router AT MOST. No settings have been changed and network disconnects/interruptions in Access are happening every few minutes. I'm totally confused and convinced it is router related in some way.
Any ideas or recommended changes?
Thanks in advance!