swap tables when more than one table is linked to primary ..

thanks Arvin, but my Linked Table Manager is greyed out and wont let me use
it, so it must be somewhere else, any more ideas?



"Arvin Meyer [MVP]" wrote:

> I think you may be looking for the Linked Table Manager. It is now in the
> Database Tools tab, slightly to the right of center.
> --
> Arvin Meyer, MCP, MVP
> [URL="http://www.datastrat.com"]http://www.datastrat.com[/URL]
> [URL="http://www.mvps.org/access"]http://www.mvps.org/access[/URL]
> [URL="http://www.accessmvp.com"]http://www.accessmvp.com[/URL]
>
>
> "wheather girl" wrote in message
>
> >I am using office 2007 and have linked a few tables to my primary master
> > table, and is working fine. Only problem is, that now I need to swap back
> > to
> > a previious table that is still linked to the primary table, and i cant
> > seem
> > to find any where on my menus on how to do this. Its not the same as
> > office
> > 2003 and quite frankly they have changed too many things and I dont like
> > it.
> > But thats another story. If there is someone that can help, that would be
> > great.
> > thanks
>
>
>
 >> Stay informed about: swap tables when more than one table is linked to primary .. 

That sounds like either an installation problem, or perhaps a permissions
problem. The Linked Table Manager should never be disabled.
 >> Stay informed about: swap tables when more than one table is linked to primary .. 

thanks for the advice Arvin, I will look into it

"Arvin Meyer [MVP]" wrote:

> That sounds like either an installation problem, or perhaps a permissions
> problem. The Linked Table Manager should never be disabled.
> --
> Arvin Meyer, MCP, MVP
> [URL="http://www.datastrat.com"]http://www.datastrat.com[/URL]
> [URL="http://www.mvps.org/access"]http://www.mvps.org/access[/URL]
> [URL="http://www.accessmvp.com"]http://www.accessmvp.com[/URL]
>
>
> "wheather girl" wrote in message
>
> > thanks Arvin, but my Linked Table Manager is greyed out and wont let me
> > use
> > it, so it must be somewhere else, any more ideas?
> >
> >
> >
> > "Arvin Meyer [MVP]" wrote:
> >
> >> I think you may be looking for the Linked Table Manager. It is now in the
> >> Database Tools tab, slightly to the right of center.
> >> --
> >> Arvin Meyer, MCP, MVP
> >> [URL="http://www.datastrat.com"]http://www.datastrat.com[/URL]
> >> [URL="http://www.mvps.org/access"]http://www.mvps.org/access[/URL]
> >> [URL="http://www.accessmvp.com"]http://www.accessmvp.com[/URL]
> >>
> >>
> >> "wheather girl" wrote in message
> >>
> >> >I am using office 2007 and have linked a few tables to my primary master
> >> > table, and is working fine. Only problem is, that now I need to swap
> >> > back
> >> > to
> >> > a previious table that is still linked to the primary table, and i cant
> >> > seem
> >> > to find any where on my menus on how to do this. Its not the same as
> >> > office
> >> > 2003 and quite frankly they have changed too many things and I dont
> >> > like
> >> > it.
> >> > But thats another story. If there is someone that can help, that would
> >> > be
> >> > great.
> >> > thanks
> >>
> >>
> >>
>
>
>
 >> Stay informed about: swap tables when more than one table is linked to primary .. 

How do I check or change the permissions for the Linked Table Manager? As it
stills seems to be disabled.



"wheather girl" wrote:

> thanks for the advice Arvin, I will look into it
>
> "Arvin Meyer [MVP]" wrote:
>
> > That sounds like either an installation problem, or perhaps a permissions
> > problem. The Linked Table Manager should never be disabled.
> > --
> > Arvin Meyer, MCP, MVP
> > [URL="http://www.datastrat.com"]http://www.datastrat.com[/URL]
> > [URL="http://www.mvps.org/access"]http://www.mvps.org/access[/URL]
> > [URL="http://www.accessmvp.com"]http://www.accessmvp.com[/URL]
> >
> >
> > "wheather girl" wrote in message
> >
> > > thanks Arvin, but my Linked Table Manager is greyed out and wont let me
> > > use
> > > it, so it must be somewhere else, any more ideas?
> > >
> > >
> > >
> > > "Arvin Meyer [MVP]" wrote:
> > >
> > >> I think you may be looking for the Linked Table Manager. It is now in the
> > >> Database Tools tab, slightly to the right of center.
> > >> --
> > >> Arvin Meyer, MCP, MVP
> > >> [URL="http://www.datastrat.com"]http://www.datastrat.com[/URL]
> > >> [URL="http://www.mvps.org/access"]http://www.mvps.org/access[/URL]
> > >> [URL="http://www.accessmvp.com"]http://www.accessmvp.com[/URL]
> > >>
> > >>
> > >> "wheather girl" wrote in message
> > >>
> > >> >I am using office 2007 and have linked a few tables to my primary master
> > >> > table, and is working fine. Only problem is, that now I need to swap
> > >> > back
> > >> > to
> > >> > a previious table that is still linked to the primary table, and i cant
> > >> > seem
> > >> > to find any where on my menus on how to do this. Its not the same as
> > >> > office
> > >> > 2003 and quite frankly they have changed too many things and I dont
> > >> > like
> > >> > it.
> > >> > But thats another story. If there is someone that can help, that would
> > >> > be
> > >> > great.
> > >> > thanks
> > >>
> > >>
> > >>
> >
> >
> >
 >> Stay informed about: swap tables when more than one table is linked to primary .. 

I think you might be talking about related tables here, not linked tables. A
linked table is one where the table is held in a separate 'back end' database
and the current database holds a link to it. This is how the same data are
shared by multiple users across a network. A related table is one where rows
in one table map to rows in another, usually in a one-to-many relationship, e.
g. a table Customers might be related to a table Orders on CustomerID.

What I suspect you may be referring to are sub-datasheets, which appear in
datasheet view of a table when you click on the + sign to the left of each
row. Unfortunately I can't give you an answer to your question as I don't
use Access 2007, but the real solution is not to view or edit data in raw
datasheet view, but via forms. You can then include subforms bound to the
related tables on a form bound to your main table. By putting each subform
on a separate page of a tab control for instance, you can have the data from
the main tables current record in controls above the tab control, and then
tab to whichever related table you wish to view on the tab control, where it
can be shown in a continuous subform.

Ken Sheridan
Stafford, England

wheather girl wrote:
>I am using office 2007 and have linked a few tables to my primary master
>table, and is working fine. Only problem is, that now I need to swap back to
>a previious table that is still linked to the primary table, and i cant seem
>to find any where on my menus on how to do this. Its not the same as office
>2003 and quite frankly they have changed too many things and I dont like it.
>But thats another story. If there is someone that can help, that would be
>great.
>thanks
 >> Stay informed about: swap tables when more than one table is linked to primary .. 

Ken
Yes your correct, I'm talking about related tables and yes a subdata sheet.
So now that we got that straight, I still need to be able to swap it back to
the other sub data sheet. But thanks for your advice on the subforms, I
will look into it.
So if anyone can now answer my question, would be much appreciated.

thanks

"KenSheridan via AccessMonster.com" wrote:

> I think you might be talking about related tables here, not linked tables. A
> linked table is one where the table is held in a separate 'back end' database
> and the current database holds a link to it. This is how the same data are
> shared by multiple users across a network. A related table is one where rows
> in one table map to rows in another, usually in a one-to-many relationship, e.
> g. a table Customers might be related to a table Orders on CustomerID.
>
> What I suspect you may be referring to are sub-datasheets, which appear in
> datasheet view of a table when you click on the + sign to the left of each
> row. Unfortunately I can't give you an answer to your question as I don't
> use Access 2007, but the real solution is not to view or edit data in raw
> datasheet view, but via forms. You can then include subforms bound to the
> related tables on a form bound to your main table. By putting each subform
> on a separate page of a tab control for instance, you can have the data from
> the main tables current record in controls above the tab control, and then
> tab to whichever related table you wish to view on the tab control, where it
> can be shown in a continuous subform.
>
> Ken Sheridan
> Stafford, England
>
> wheather girl wrote:
> >I am using office 2007 and have linked a few tables to my primary master
> >table, and is working fine. Only problem is, that now I need to swap back to
> >a previious table that is still linked to the primary table, and i cant seem
> >to find any where on my menus on how to do this. Its not the same as office
> >2003 and quite frankly they have changed too many things and I dont like it.
> >But thats another story. If there is someone that can help, that would be
> >great.
> >thanks
>
> --
> Message posted via AccessMonster.com
> [URL="http://www.accessmonster.com/Uwe/Forums.aspx/access/200910/1"]http://www.accessmonster.com/Uwe/Forums.aspx/access/200910/1[/URL]
>
>
 >> Stay informed about: swap tables when more than one table is linked to primary .. 

That is different. Go to the design view of the table, then right-click on
the title bar and choose Properties. You will see the "Subdatasheet"
property, which might have "[Auto]" in it. click the down arrow and choose
the table you want.

That brings up to other issues:

1. Working directly in the tables should never be allowed for any user other
than the developer of the database, since there is no way to control what a
user can do there.

2. Subdatasheets greatly affect performance if there are very many records
in the database.
 >> Stay informed about: swap tables when more than one table is linked to primary ..