Database path in internat

[rickyfong]

In a internat environment, PC1 and PC2 is "front" and PC3 is "end" with database stored in it. How can user know the PC3 is switch-on or else error-message such as database not found or invalid path may appeared.

For the time being I am already using hyper link to link front with end. For instance---> \\PC112\STOCK\7-29\. Thanks a lot!!

 

[Vassago]

Really, the error that shows it's an invalid path should be enough to know tha the database cannot be reached. There isn't a way to tell if a computer is powered on if it's not because your computer won't be able to communicate with a powered off computer.

There are some computers that have an option to power-on via LAN/WAN if that's what you ultimately want to do.

https://www.raymond.cc/blog/how-to-remotely-turn-on-computer-from-lan-and-wan/

 

[rickyfong]

Thanks! How can my Access system VBA coding detects the error and show error message as part of the system instead the ACCESS showing error message and force the user to end the system?? Thanks again!!

 

[rickyfong]

Anyone!!?? Please.........and THANKS!

 

[vbaInet]

I suppose if GetObject() fails that's enough to know that the PC is not reachable. Or even more simply if you try to read a file on the PC, that again is another sign.

 

[vbaInet]

... of course you'll need to know the exact error message to respond to.

 

[vbaInet]

And a better option is pinging the computer and check if it fails. Or I would imagine you can use WMI.

To be honest this question is best suited for a Systems Admin and whatever they advise you can look to do it in VBA or in a scripting language.