Detect speed connected to Local Network

[SurveyorinVA via AccessMonster.com]

Good day,

I am looking at deploying an application to both desktop units with a
connection speed to a local network server of 100 mbps and sevaral laptop
users that are connected wirelessly (54 mbps). Is there a way through VBA to
detect the connection speed.

If the connection speed is 100 mbps than it will open normally, but if it
detects this lower connection speed, I will generate code to stop some forms
from opening in the background.

Any help in this would be greatly appreciated.

Chris F.

 

[Albert D. Kallal]

I doubt that you can detect the connection speed, since if you open up the
network connection in both cases, they OFTEN show 100 base connection for
those wireless connections.

Since the 54g connection uses a LOT OF compression, sometimes the actually
throughput can reach the same as a wired network without any compression.
So, actually throughputs very by a HUGE margin when using those advanced
wires systems with lots of compression. In other words,t he speed variables
by huge margins.

You might however be able to detect if you on wireless, and that would be
good enough warning. (so, the speed detection likely would return 100, but
just checking for wireless should solve your needs).

While we wait for someone to come up with a means to detect your wireless,
you should take a VERY CAREFUL read of my article here, as it explains why
you can't use ms-access on a wireless network:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

Read the paragraph in corruption..and you see what I am talking about....

 

[David W. Fenton]

I am looking at deploying an application to both desktop units
with a connection speed to a local network server of 100 mbps and
sevaral laptop users that are connected wirelessly (54 mbps). Is
there a way through VBA to detect the connection speed.

You can't use Access across a wireless network because it's too
unreliable. With 54g the bandwidth may be perfectly sufficient, but
if the signal is not rock-solid 100% constant, you'll corrupt your
database.