1

Topic: To consider parameter "a basis title" from other file Access

Dear forum;
It is necessary to consider a basis title using VBA from other file Access 2016. I try from current basis - all :

CurrentDb. Properties ("AppTitle").Value

If I open another swears that there is no such parameter:

db_n as new adodb.connection
with db_n
.Provider = "Microsoft. ACE.OLEDB.16.0"
.connection = "blabla"
.open
end with
debug.print db_n. Properties ("AppTitle").Value <= here 

Tried to pull out all list of accessible parameters, throws out the whole heap of everything, and among them really is not present AppTitle. A question: how to receive this parameter from other basis?

2

Re: To consider parameter "a basis title" from other file Access

IFK;
Obvious thing I will tell, but TypeName (db_n)! = TypeName (CurrentDb), you are explicit not from this object AppTitle try to extract

3

Re: To consider parameter "a basis title" from other file Access

And somehow so:

Set db_k = New Access. Application
db_k. OpenCurrentDatabase ("...\Database.accdb")
Debug. Print (TypeName (db_k. CurrentDb))
Debug. Print (db_k. CurrentDb. Properties. Count)
db_k. CloseCurrentDatabase
Set db_k = Nothing

Yes, and for me in 2016 does not work CurrentDb. Properties ("AppTitle").Value, there is no such property

4

Re: To consider parameter "a basis title" from other file Access

4z4r, it turned out through Debug. Print db_k. CurrentDb. Properties ("AppTitle").Value. Thanks!

5

Re: To consider parameter "a basis title" from other file Access

4z4r wrote:

for me in 2016 does not work CurrentDb. Properties ("AppTitle").Value, there is no such property

Because it not a basis title, and the application title set in Parameters of start.
If it is not set - it and is not present.