Check if on wireless network

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

neshev - 20 Jul 2007 23:46 GMT

Hi Guys. I have created a standalone database for a client that is set up on
all their laptops. Their employees enter information onto the database on the
laptop and when they return to the office they sign off the information and
it transfers over the wireless network to the Master database on the server.
At the moment, each employee is asked when logging on whether they are in the
office or outside. if they are in the office, the information transfers. Does
anybody know how to check whether the computer is connected to the wireless
network by using code rather than asking. If this can be done, the data can
automatically transfer when the database is opened and new schedule
information can be uploaded to the laptop. so I need code to search for a
specified connected network. Any help with this will be great

Thanks

NS

Reply to this Message

'69 Camaro - 21 Jul 2007 01:30 GMT

Hi.

> I have created a standalone database for a client that is set up on
> all their laptops. Their employees enter information onto the database on
[quoted text clipped - 3 lines]
> it transfers over the wireless network to the Master database on the
> server.

Allowing an Access database to connect to another database file via a
wireless network is a recipe for corrupted database files. It is not
recommended. Use Ethernet cables to connect the laptops to the office
network.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Reply to this Message

neshev - 21 Jul 2007 09:20 GMT

Thanks Gunny.
My question was - is there a way that the database can check if the network
is connected to the laptop. So if the ethernet cable is connected, is there a
way that the database can detect that the server is available. The database
is stored on the C drive of the laptops and only connects to the server when
transferring data.

regards

neil

> Hi.
>
[quoted text clipped - 19 lines]
> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
> info.

Reply to this Message

David W. Fenton - 21 Jul 2007 13:57 GMT

> My question was - is there a way that the database can check if
> the network is connected to the laptop. So if the ethernet cable
> is connected, is there a way that the database can detect that the
> server is available. The database is stored on the C drive of the
> laptops and only connects to the server when transferring data.

After my sig is code that should be usable in any application with
no added references. If you want to check for a file instead, change
the objFSO.FolderExists to objFSO.FileExists and supply a filename
as the argument, instead.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Public Function CheckForNetwork(strFolderToCheck As String, _
Optional bolClear As Boolean = False) As Boolean
Static objFSO As Object 'late binding

If bolClear Then Set objFSO = Nothing: Exit Function

If objFSO Is Nothing Then
Set objFSO = CreateObject("Scripting.FileSystemObject")
End If
If objFSO.FolderExists(strFolderToCheck) Then
CheckForNetwork = True
Else
MsgBox "Not connected to the network!", vbExclamation, _
"Not connected"
End If
End Function

Reply to this Message

neshev - 23 Jul 2007 14:58 GMT

Thanks for your help David. great help to my database. appreciate it.

Neil

> > My question was - is there a way that the database can check if
> > the network is connected to the laptop. So if the ethernet cable
[quoted text clipped - 6 lines]
> the objFSO.FolderExists to objFSO.FileExists and supply a filename
> as the argument, instead.

Reply to this Message

David W. Fenton - 21 Jul 2007 13:54 GMT

> Allowing an Access database to connect to another database file
> via a wireless network is a recipe for corrupted database files.
> It is not recommended. Use Ethernet cables to connect the laptops
> to the office network.

If you use indirect replication to transfer the data, there's no
danger on a wireless LAN (or over a WAN, for that matter).

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message