Is there any SQL statement who retrieve the file name for a .mdb DB ?

There is something similar in SQLite: SELECT file FROM pragma_database_list WHERE name='main'

I need the same thing, but for Microsoft Access Database.

CodePudding user response：

You need VBA for this:

DbName = CurrentProject.Name

There is no SQL expression/function.