Access metadata schema undocumented?

[Paul]

For a GetSchema("Columns");

I am seeing various undocumented codes.

What is the column type for COLUMN_FLAGS=122 and DATA_TYPE=3?

What is the column type for COLUMN_FLAGS=90 and DATA_TYPE=3? I think it's an autonumber field, but I've never seen anything official.

Is this documented anywhere?

 

[Douglas J. Steele]

Microsoft has never released documentation on the file format.

 

[Tony Toews [MVP]]

For a GetSchema("Columns");

Where are you running this from? I don't see this inside Access. Or
is this Access 2007? Is this ADO? Please post the rest of the code
so I can run this myself.

I am seeing various undocumented codes.

What is the column type for COLUMN_FLAGS=122 and DATA_TYPE=3?

What is the column type for COLUMN_FLAGS=90 and DATA_TYPE=3? I think it's an autonumber field, but I've never seen anything official.

The Column_flags could be bit operators. That is 90 is 64 +16 + 8 +
2. There are some properties when you go to the fields property
collection that might be relevant.

The data_type of 3 could correspond to the dbInteger constant which
also has a value of 3.

Tony


--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

For a GetSchema("Columns");

I am seeing various undocumented codes.

What is the column type for COLUMN_FLAGS=122 and DATA_TYPE=3?

What is the column type for COLUMN_FLAGS=90 and DATA_TYPE=3? I
think it's an autonumber field, but I've never seen anything
official.

Is this documented anywhere?

If you want metadata about a Jet database, then use DAO. It has
everything you need, because it's Jet's native data access
interface.