Reference > Functions reference > Design functions > DatabaseNames


Returns a list of the names of all files open on the computer.





Data type returned 


Originated in version 

6.0 or earlier


Listed items are separated by carriage returns. The names returned do not include file extensions.


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:

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:

PatternCount (
FilterValues ( DatabaseNames ; "Customers" ) ;

This will tell you how many files named Customers are open.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas