NoGurru
asked on
MS Access Wi-Fi speeds
Can anyone confirm that a split database with 3 mde files accessing the main data will run horribly slowly on Wi-Fi? Should I forget using W-Fi?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No points please.
Agree with Scott, at least from personal experience.
In a job several years ago, I had half a dozen people accessing a database via wired connection. Then, all of a sudden we started experiencing corruption issues at least once a day. Didn't take long to figure out that one of the guys had his desktop machine replaced with a laptop and he would wander around the building with it, wander in and out of connections and corrupt the database.
Agree with Scott, at least from personal experience.
In a job several years ago, I had half a dozen people accessing a database via wired connection. Then, all of a sudden we started experiencing corruption issues at least once a day. Didn't take long to figure out that one of the guys had his desktop machine replaced with a laptop and he would wander around the building with it, wander in and out of connections and corrupt the database.
Ditto here.
I've always found wireless networks to be very problematic and not just with Access.
My choice is to always use a wired network if at all possible.
I've had too many cases where problems were encountered with a wireless, and switching to a wired network makes them go away.
Wireless networks are fine for consumer type use where your doing e-mail or internet surfing, but for any kind of hard use, run with a wired network.
But with that said, if your going to use a wireless network, take the time to do it right; have someone come in and configure properly, do a RF survey, etc.
Half the time problems with wireless networks are not the technology, but the casual manor their approached with when being installed.
Jim.
I've always found wireless networks to be very problematic and not just with Access.
My choice is to always use a wired network if at all possible.
I've had too many cases where problems were encountered with a wireless, and switching to a wired network makes them go away.
Wireless networks are fine for consumer type use where your doing e-mail or internet surfing, but for any kind of hard use, run with a wired network.
But with that said, if your going to use a wireless network, take the time to do it right; have someone come in and configure properly, do a RF survey, etc.
Half the time problems with wireless networks are not the technology, but the casual manor their approached with when being installed.
Jim.
One other possibility is to use Remote Desktop Protocol (RDP) on your wireless client to connect to your computer/server where the database runs. We do this for all our stores where the managers and sales associates connect with their tablets.
Ron
Ron
ASKER