DatabaseNames
Returns a list of the names of all files open on the computer.
Format
DatabaseNames
Parameters
None
Data type returned
text
Originated in version
6.0 or earlier
Description
Listed items are separated by carriage returns. The names returned do not include file extensions.
Notes
- If your database is hosted on another computer,
DatabaseNames
returns a list of the names of local client and remote database files open only on the client computer.
Example 1
To determine whether Customers is one of the files currently open, use the DatabaseNames
function with the FilterValues
function in the formula:
Copy
FilterValues ( DatabaseNames ; "Customers" )
If the formula returns any text value, then Customers is open.
Example 2
If you want to know how many files with the same name are open, use the DatabaseNames
function with the PatternCount
function in the formula:
Copy
PatternCount (
FilterValues ( DatabaseNames ; "Customers" ) ;
"Customers"
)
This will tell you how many files named Customers are open.