Expand Indicator Not Showing in Datasheet View

I have an Access 2000 database which has several tables linked together using the Relationship Manager.  I can view the table in Access 2000, and the Expand Indicator (little "+" sign) appears as the leftmost column, allowing me to view the related data.

When I open this same file in 2007, the Expand Indicator does not appear.  I have converted the database to 2007 format, and that does not work either.

To be specific, I expect to double click a table name in the Tables group, have it appear in Datasheet view, and show the Expand Indicator as the leftmost column.

Why does it not work?  Where do I go to make it appear?
raburkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
puppydogbuddyConnect With a Mentor Commented:
from this link:
http://office.microsoft.com/en-us/access/HP052362201033.aspx

the value of the SubdatasheetName property can be set to a specific table or query in the database; or it can be set to None, in which case no subdatasheet will be created. To return to the default behavior, set the value of the SubdatasheetName property to Auto.


0
 
raburkAuthor Commented:
It seems that Access 2007 doesnt like to deal with linked tables for subdatasheets.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.