Microsoft Access Forum

Access Forum

Wireless Networking and Access Upload Images Link
Scott Axton
4 months ago

I was asked by my boss to set up our db on his new laptop.

I don't have a problem installing Office there. He can work with his own .docx and .xlsx files but I'm concerned about using the wireless networking for shared data / folders.

Our split db works flawlessly over the local hardwired network but I've never run it over wireless connection.

My initial response was it won't work. He had to hook in via Ethernet cable.

Does anyone here have any experience doing so?

( Richard, Alex, Adam, Kevin )

Any concerns or pitfalls I should be aware of?

Alex Hedley
4 months ago

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.

Richard Rost
4 months ago

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?

Richard Rost
4 months ago

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.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Forum Comments