Reading database properties

  • Thread starter Thread starter Alp Bekisoglu
  • Start date Start date
A

Alp Bekisoglu

Hi Experts,

What is the way to read all available properties of a database via code from
VBA? Like listing a "collection" to the debug window, a wild-card character
maybe?
I'd like to find out what I did include and what I have missed out and it is
puzzling me when I can't remember the exact property names I assigned.

Thanks in advance.

Alp
 
What is the way to read all available properties of a database via
code from VBA? Like listing a "collection" to the debug window, a
wild-card character maybe?
Click to expand...



For each prp in db.Properties
Debug.Print prp.Name; Tab(18);
' catch unprintable properties
On Error Resume Next
Debug.Print prp.Value;
' Ignore the errr
On Error Goto 0

Debug.Print

Next prp


The most useful properties, though, are located in the appropriate Document
objects. Look up help for the DAO Containers and Documents objects and
collections.

Hope that helps


Tim F
 
Thanks a lot Tim, the loop when turned into a part of a function did it! Now
I can check all my app's and find out what I've done (and not done!).
And I'll take your advice and go through DAO Containers' and the Document
Objects' help if my shakey help functions properly for once...

Thanks again,

Alp
 
if my shakey help functions properly
Click to expand...

Yeah: really weak part of Access since they got rid of proper .hlp files.
You can try searching your disk for DAO360.chm (or something close) and
open it manually. I keep a shortcut on my desktop.

B Wishes


Tim F
 
Back
Top