Linked table names not showing up in navigation pane (2007)

[Dale Fye]

I've got some code in my application that links to tables in a backend
database by creating a tabledef, connecting to the backend database, and
assigning a source table name, then appending the new tdf.

However, when I use this technique, the table names don't show up in the
navigation pane. The tables are linked, because I can query them, and open
forms that are based on them, but they don't show up in the Tables section of
the navigation pane. Anybody know how to resolve this?
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Jeff Boyce]

Dale

Not quite enough information to tell...

Have you 'jiggered' the settings on the Navigation Pane to see if the tables
are just not being displayed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dale Fye]

Jeff,

Thanks for replying.

They eventually show up, after hiding/unhiding the navigation pane a couple
of times.

I figured that once I had added the tables, just issuing a
currentdb.tabledefs.refresh would display them, like it did in 2003.

Live and Learn.

I'm still trying to get comfortable with the new nav pane and ribbon bar in
2007.