ADO: How to find DB properties?
Hi all,
I want to keep some data in the DB that are file-related.
E.g. What application-defined project is this database related to e.t.c.
I am using MS-ACCESS DB and created custom DB Properties but I do not know how to retrieve the values from ADO.
I tried
m_pDBConnection->Properties->GetItem("project")->GetValue;
but it cannot find my custom property (and any other non-custom properties)
Any suggestions?
[469 byte] By [
panayotisk] at [2007-11-18 10:00:15]
# 1 Re: ADO: How to find DB properties?
I just saw that there are at least 2 similar threads on the subject:
this (http://www.dev-archive.com/forum/showthread.php?s=&threadid=78712&highlight=Access+database+properties) and this (http://www.dev-archive.com/forum/showthread.php?s=&threadid=178247&highlight=database+custom+properties) and noone has answered.
The DB experts of the forum are not interested in such things?:(
EDITED: Ok, I found this MSDN page (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrchoosingadoordaoforworkingwithaccessdatabases.asp) that puts an end on my hopes. So it seems I will have to change my approach...
# 2 Re: ADO: How to find DB properties?
Another approach would be to have an ini file for each DB file.
But if I want to store the author and the copyright in an ini file these would be publicly available for modification. Is there any other way to store file-specific information that the user may only see (through the program) and not modify?
