Need Listing of Db Properties

[TheAceMan1]

Howdy All . . .

A few years ago I completed a Db that allows me to view, edit, and add Db properties (custom) for any Db (user provides the path/filename to the db) ... password protected (via db or access security) or not. It works extremely well! I can do what I want!

My problem involves tagging custom Db properties [blue](properties created by the admin/user ... aka non access!)[/blue]. The only way to do this is to ping against a table of known access Db properties. I have the table, and for the most part its complete.

I just need a complete listing of of access Db properties
to [blue]prevent false positives![/blue]

Anyone know where I can get such a listing of access Db properties!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jedraw]

Interesting question. I looked and couldn't find such a list.
Thought it might be somewhere via Object browser but no luck.

I did run this

Sub Prop2()
Dim db As DAO.Database
Dim i As Integer
Set db = DBEngine(0)(0)
For i = 0 To db.Properties.Count - 1
Debug.Print "d.Property(" & i & ")  " & db.Properties(i).Name
Next i
End Sub

to get

d.Property(0)  Name
d.Property(1)  Connect
d.Property(2)  Transactions
d.Property(3)  Updatable
d.Property(4)  CollatingOrder
d.Property(5)  QueryTimeout
d.Property(6)  Version
d.Property(7)  RecordsAffected
d.Property(8)  ReplicaID
d.Property(9)  DesignMasterID
d.Property(10)  Connection
d.Property(11)  ANSI Query Mode
d.Property(12)  Themed Form Controls
d.Property(13)  AccessVersion
d.Property(14)  Build
d.Property(15)  ProjVer

but I'm certain this is not exhaustive.

Are you working with something like this ??

http://allenbrowne.com/ser-09.html