Get DB file name

user_3775374 0
Viewed 35

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.

ms-access
1 Answers

You need VBA for this:

DbName = CurrentProject.Name

There is no SQL expression/function.

user_35272970
Related