CODEWITHSUNDEEP
ms-access
Flaviu_
Flaviu_

Reputation: 1346

Get DB file name

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.

Upvotes: 1

Views: 338

Answers (1)

Gustav
Gustav

Reputation: 55841

You need VBA for this:

DbName = CurrentProject.Name

There is no SQL expression/function.

Upvotes: 1

Related Questions