MVP's Rock/Detect network on startup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I am finally getting around to re-designing some of messes I created when I
first started working in Access. This newsgroup has enabled me to increase
my knowledge exponentially. Thanks to all!

My challenge to you this time:
Can Access reach out and detect a network connection. I have a user on a
laptop and I want to automate his updates. I have an idea of how the code
should look, just don't know the right calls.

If networkconnection found Then
DoCmd.RunSQL "run update and append queries"
Else
do nothing
End If

this is not actual code, just an example of what I would like to do.

Thanks for Enabling me,
NickX
 
hi Nick,

Nick said:
Can Access reach out and detect a network connection. I have a user on a
laptop and I want to automate his updates. I have an idea of how the code
should look, just don't know the right calls.
Click to expand...
Don't reinvent that wheel. Use Access replication:

support.microsoft.com/kb/q182886/


mfG
--> stefan <--
 
Thank you for your response, Alex:

In the old version of the database I have the neccessary tables link into
this database, so they are there when jacked into the network. On the
Switchboard I have a button that cycles through the appropriate update and
append queries that upload to local tables and download to a back-up Db. The
upload data comes from various Db's on the network, none of them identical to
this Db.
I would like to do the same thing with the new Db, just silently and out of
view. I would probably assign the process to the on open event of the
"Splash" form.
do you mean that you have other database on network? then you can try to
open this database using dbengine.opendatabase(), and if it fails - then
network connection is not available
Click to expand...

Could I use this method to fake it out, or is there another way to detect
the network?

Thanks in advance,
Nick X
 
Back
Top