Is the wireless known to drop?
I don't see an issue if it's fast and reliable
Adam Schwanz 4 months ago
I've used wireless inside the building and it seems to be OK as long as the wireless connection is stable. I know for people I've built for that take their tablets and stuff outside to walk around and work (high chance of wifi trouble), I suggest them to instead remote into a PC in the building on the network and run access on that machine, that way if the tablet is going in and out of signal won't have to worry about corruption problem with access just sitting on the PC inside.
Should be OK if your WiFi is strong and fast. I use my database over the WiFi at home without problems. If it's slow or crashes a lot, make him a scaled-down version of your database and take the datasets into consideration (don't open forms that pull a bunch of records at once, for example). This is almost always a "try and see" scenario.
Scott Axton 4 months ago
Thanks guys for the feed back. My router is a pretty top notch unit. Don't remember the brand but it is meant to be for pole mount and long distance. I use it all day for other things but have always been under the impression that it was a no-no for Access. I don't have dropping problems at all.
Richard how do you limit amounts of data being pulled down at once? Is there a way to stress test my db to see if there would be issues?
Well, it's little things... like if you have to run a query the pulls ALL of the records across the wire (air). Try to avoid that. Or if you need multiple iterations of the same table, copy the records you need down locally first. That's why SQL Server is so good, because it will send you JUST the records you need. Desktop Access has to pull the entire table over the wire.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.