SubDatasheets from ACCESS 2000 to ACCESS 2003

[johnsonlnl29]

My database was created in ACCESS 2000 and I was able to view subdatasheets
in linked tables. I upgraded to ACCESS 2003 and now I am not able to view
subdatasheets in linked tables; however, the subdatasheets are still in the
root table. What do I need to do in order to view the subdatasheets in the
linked tables?

 

[Tim Ferguson]

What do I need to do in order to view the subdatasheets in the
linked tables?

Create a query?

Tim F

 

[johnsonlnl29]

I realize I COULD query, but I'm more baffled at the fact that the
subdatasheets don't follow over to ACCESS 2003. I have some users that use
the subdatasheets and are not too ACCESS literate. Just thought it would be
easier if I could use the subdatasheets than create a query. Any additional
help would be greatly appreciated. Thanks in advance!

 

[John Vinson]

I realize I COULD query, but I'm more baffled at the fact that the
subdatasheets don't follow over to ACCESS 2003. I have some users that use
the subdatasheets and are not too ACCESS literate.

Such users are very commonly found, and you should cater to their
needs - by creating Forms with Subforms. Users should in general never
need to see any table or query datasheet, with or without
subdatasheets.

An easy to use application is usually hard to create, and vice versa!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps