Table Links

[Guest]

You know how Access will let you select from a list which table you want to
show when you expand the node in Datasheet view?

How do you delete that link?? Let's say you changed your mind and want to
show a different table when you expand….(I have a table and when I expand the
node on one of the records I get records from a table it no longer has a
relationship with…)

Thanks

 

[Guest]

You can remove a subdatasheet when the table is open in preview mode. To do
so, click on:
Format > Subdatasheet > Remove.

If you want to define a new subdatasheet, click on: Insert > Subdatasheet...
and select either a table or query.

That being said, your best bet is to simply set ALL subdatasheets = None,
especially if this is a shared multi-user database with the data on a file
server. Two reasons for this statement:

1.) First, all data operations (additions, edits, & deletions) should be
carried out using forms, not directly in the tables and
2.) Contributes to slower performance

BUG: Slow performance on linked tables in Access 2002 and Office Access 2003
http://support.microsoft.com/kb/275085


Tom
http://www.access.qbuilt.com/html/expert_contributors.html
___________________________________

:

You know how Access will let you select from a list which table you want to
show when you expand the node in Datasheet view?

How do you delete that link?? Let's say you changed your mind and want to
show a different table when you expand….(I have a table and when I expand the
node on one of the records I get records from a table it no longer has a
relationship with…)

Thanks