This function checks the presence/status of a specified database file, denoted by an descriptive text output. Specification of a file extension is optional, and if omitted, the function will check for either one of motion (DBM) or force (DBF) database files.
IsValidDatabaseAsText (string DatabaseName)
DatabaseName (string). The full path name to the relevant database.
‘Database is Valid’ (if the specified database is valid)
‘Database has changed’ (if the database file is present, but has been updated since Excel was launched)
‘Force Database is missing’ (if the force database is missing)
‘Motion Database is missing’ (if the motion database is missing)
’Database name contains invalid characters’ (if the path or filename contains invalid characters)
‘Database name is empty’ (if the database filename is empty)
‘Database is Invalid’ (if the specified database is invalid)