[RESOLVED] [VBA/ADO] Check for database present

[Ggalla1779]

Hi all

I have an excel spreadsheet that pulls data out of Access via ADO

ie

Set cn = New ADODB.Connection
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDb & ";"
    Set rs = New ADODB.Recordset
 
    With rs
        Set .ActiveConnection = cn
        .Open strQry

When these spreasheets are sent offsite I would like to put a check in for no database and if none just skip the on load routine to refresh the Excel data from the database.... how cleanly can I test for the database not being there? So the offsite doesnt see an error

cheers George