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.

Related topics