Get active wireless network name in MS Access VBA

Any suggestions for code to get active wireless network name in MS Access?

BTW: I tried:
https://www.experts-exchange.com/questions/28350821/Getting-Wireless-Connection-Name-Through-VBA.html
the code didn't work.
LVL 39
thenelsonAsked:
Who is Participating?
 
thenelsonConnect With a Mentor Author Commented:
I found the answer at:
https://stackoverflow.com/questions/36297043/access-vba-obtain-wireless-network-name-connected
The first listing of code on that page starting with:
Option Explicit

Private Const DOT11_SSID_MAX_LENGTH As Long = 32

The function:
GetConectedSSID
returns the name of the active wireless connection.
0
 
Sagar KhatalstudentCommented:
set access permission
0
 
thenelsonAuthor Commented:
>set access permission
I don't understand
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
PatHartmanCommented:
I'm not sure why that answer was accepted in the thread you linked to.  The code doesn't compile.  The GetWirlessName function is missing.  I tried fixing the spelling error but that didn't fix the issue.
0
 
PatHartmanCommented:
I forgot to warn you that running Access on a wireless network is dangerous.  Access cannot gracefully recover from network interruptions and they happen frequently on a wireless network.  If they happen at a "bad" time, your BE will be corrupted.
0
 
thenelsonAuthor Commented:
Thanks for the warning but Access is not running on a wireless network. We have two computers running Access each running locally which run a home grown replication routine several times daily to keep the data in sync.  I wanted to know the name of the wireless network to allow activation of routines I only want to run at our office location, not at home.
0
 
PatHartmanCommented:
I didn't test the code so I don't know if it returns all available networks or just the network you are connected to.  If it is just the network you are connected to, then you are running on a wireless network and linking to a Jet/ACE BE over wireless is extremely dangerous.
0
 
thenelsonAuthor Commented:
Nope, as I said, i am not linking to a BE over the network. There are separate BEs local on each computer and I created a replication routine outside of Access that runs several times a day to keep the two BEs in sync. The routine I created is designed to handle network dropouts and I tested it extensively. It has operated flawlessly for about 15 years even if I turn off the computers in the middle of the run.
0
 
PatHartmanCommented:
That's fine.  Since you were asking about wireless networks and Access in the same question, I was just trying to clarify for future readers that running an Access app on a wireless network is dangerous.
0
 
thenelsonAuthor Commented:
I found the answer on anther service.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.