[RESOLVED] detecting a missing database

[GaryMazzone]

I normaly do the following code:

Set FSys = New FileSystemObject
If gstrDBLoc = "" Then gstrDBLoc = App.Path
If gstrDBName <> "" And FSys.FileExists(gstrDBLoc & "\" & gstrDBName) Then
    OpenDB
Else
    fDBLoc.Show
    Exit Sub
End If
 
If Not FSys Is Nothing Then Set FSys = Nothing

If the database is not there I open a form and allow the user to point me to the new database location. Altough I do not use the data controls you can just exit out with a message if the database is required to be in a specific place.

[Hack]

If the database is not there I open a form and allow the user to point me to the new database location.

Regardless of what method you end up selecting davypipes, this is an outstanding idea!

(BTW: Why did you double post this question? )

[davypipes]

sorry for double posting!!! how can i check all my posts(new+old) the moment i log in?is there such a link,coz sometimes i end up searching for my posts using advanced search!!

anyhooo... thanks guys for all your help...though i dont think the above codes will work with what i have since ive used the built in connectin objects provided by VB(dataenvironment..connection1..ie:have not used code to connect)
For the database path, i only put the database name,which surprisingly regardless of where i put the folder ,the application still sees the database...coz its within the same folder! now my only problem is to detect and inform the user when the database is missing!!! so guys...emmm...how do i do that in this kind of scenario?