MS Access metadata repository generation query, matrix generationquery, table-generation query, arra

[Roy Roebuck]

Hi:

In 2002 I asked the microsoft.public.access.tablesdbdesign group a
question about how to "automatically build tables from field
defintions rows in another table".

I never received an answer that fit my needs, but the topic has come
up again in my work. Other terms that might describe what I'm looking
for are: metadata repository query, matrix generation query, table-
generation query, array-generation query.

Consider the following tab-delimited layout of an MS Access Query in
Datasheet view.

Class_Name Attribute_Name Attribute_Type Attribute_Length Value_Name
Dog Gender Char 10 Female
Dog Breed Char 30 Beagle
House Bathroom Number NA 3
House Bedrooms Number NA 3
Person Last Name Char 20 Smith
Person First Name Char 20 Joe
Person Birth Year Number NA 1951

How can I use the non-programming features of MS Access 2000, 2003, or
2007 to automatically generate a Datasheet view that would provide
form or query data entry functionality that would look like the
following Tab-delimited layout for Class=Person (Attributes: First
Name, Last Name, Birth Year)

First Name Last Name Birth Year
Joe Smith 1951

Note that I want to be able to add "values" to the cells of the class/
attribute matrix for data entry purposes.

Roy

(Yes, I want to build a table-definition metadata tool on top of MS
Access's ISAM database engine, as well as on top of a SQL DBMS.)

 

[John W. Vinson]

How can I use the non-programming features of MS Access 2000, 2003, or
2007 to automatically generate a Datasheet view that would provide
form or query data entry functionality that would look like the
following Tab-delimited layout for Class=Person (Attributes: First
Name, Last Name, Birth Year)

If you insist on doing it without any programming, I don't believe it's
possible. You'll need to actually generate a SQL string and I don't think that
can be done without programming.

Is an answer using the appropriate tool - VBA programming - unacceptable?