[AccessD] Access 2007 System Table

Martin,

  Sounds like a pretty good guess, but since it is just a guess, sounds like
a quick test is in order.
 
  Create a DB with a single table with no complex data type.  Check those
system tables and they should be empty.  Then alter the table design and
check again.  You should find something in there at that point.  That should
be enough to verify that they are indeed being used for what you think.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, January 31, 2007 3:57 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2007 System Table

There are two fields in the following system table in Access 2007
 
MSysComplexColumns
 

ConceptualTableID    ,     FlatTableID

I think they are related to the hidden table that deals with complex data
types in Access 2007 but cant say this for sure. Anyone any idea? MS will
not tell me what they are!

Martin

 

 

 

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477