Testing DAO connection to database located accross Network

[Sink_or_Swim]

I have a database split in to a front-end and a back-end. The back-end is out on the network and While my splash screen loads i want to ensure that before I load the main form I am connected to the database.

I need a good, clean way to test the connection to the database. I was opening a recordset to test the connection but this seems like a lot of overhead. Is there a more simple method I can use?

 

[Banana]

The safest and simple way I've came across is the OpenDatabase method, which you can close after verifying it's well and alive.

Opening a empty recordset is another alternative, and sometime people do recommend that you leave it open to keep a persistent connection and thus improve performance.