FileIsValid

Tests if a database is valid. This means whether it exists and contains at least one record.

Compatibility

Available as of IDEA version 9.0

Syntax

FileIsValid(fileName as String)

Parameter

fileName

Name of the database to be searched, with or without extension.

Return Value

True if database is valid.

Example

Dim SimpleCommands As Object 
Dim fileName As String 

Sub Main 
	Set SimpleCommands = SmartContext.MacroCommands.SimpleCommands 

	'Check validity of database fileName. 
	If SimpleCommands.FileIsValid(fileName) Then 

		'Do something with fileName. 
	End If 

	'Release object. 
	Set SimpleCommands = Nothing 
End Sub

Copy example