network status

[krishnanhemanth]

hi all
i have split my database into front end and back end.
the backend is on a server.
the front end is deployed on user systems.
what i want is .....
the login form should display "NETWORK OKAY" if the front end is connected to the back end
how do i do that
please help
hemanth

 

[stopher]

Take a look at the DIR function and then just test for a non-empty string. It may throw an error if the file/directory is not found but you can deal with this with the error handler.

hth
Chris

 

[ghudson]

To test if the front end is connected to the back end you could do a Dcount() on one of the linked tables and you should get an error message if the link table cannot be found. Then you can trap for that error number and give the user a friendly error messge. You could take is a step further and give them a method to reconnect their front end to the back end. Search around for their are other threads discussing that.