Read ACCDB Title

[FaulknerCJ]

Good Morning All



Firstly, thank-you for taking the time to read this post.

I need to read the apptitle property from an ACCESS DB, an ACCDB instead of an MDB however.

Normally I'd just use something like:-

Dim PathAndNameOfDBGoesHere as string
Dim db As DAO.Database
PathAndNameOfDBGoesHere="example path to mdb"
Set DB = PathAndNameOfDBGoesHere
debug.print db.properties("AppTitle")

and return what I need however I am struggling to do this for an ACCDB.

Please note that I need to run this outside of the ACCDB, i.e. I am referencing the DAO library in the example above in a VB program and then passing the name of the DB. I need to do the same for the ACCDB and will include the relevant library via references.

Any help, pointers would be greatly appreciated

Many thanks

--
Christopher.

[FaulknerCJ]

Hi All
Have sorted in case anyone's interested. Added the Microsoft 14.0 Access Library and used the same code above and works a treat.
Thanks for your time
--
Christopher.