How to unlink a protected table?

[Wayfarer]

I have a table given me as "linked" table, which means I can not change
anything. There are 135621 rows and 50 fields, and there was no Primary
Key designated.

I want to to able to link one field from it to another table from another
source, so I can query from both. Each has a field that contains an unique
ID number, although the linked table has leading zeros in that field so that
each ID is 8 numbers, and the other table stores them as they are without
leading zeros.

No luck in finding help with my Access manual (or at least I may not know
enough to find it) and what I find online talks about how to link and I want
to know how to unlink a protected table so I can work with it.

Any help appreciated. Thanks.

--
Marta
(if you email me directly you need to remove the X )

[Jack MacDonald]

Re: How to unlink a protected table?

Not really sure what difference it makes whether the table is linked
-- I suspect it makes no difference. This SQL will query both tables:

SELECT tblWithNumericK eyfield.Numeric Field,
tblWithNumericK eyfield.SomeOth erInfor, tblWithTextKeyf ield.TextKey,
tblWithTextKeyf ield.SomeValue
FROM tblWithNumericK eyfield INNER JOIN tblWithTextKeyf ield ON
tblWithNumericK eyfield.Numeric Field =
val(tblWithText Keyfield.TextKe y);


Modify the table names and field names as appropriate for your tables.


On Sun, 25 Jan 2004 20:20:29 GMT, "Wayfarer" <Wayfar1X@swbel l.net>
wrote:
[color=blue]
>I have a table given me as "linked" table, which means I can not change
>anything. There are 135621 rows and 50 fields, and there was no Primary
>Key designated.
>
>I want to to able to link one field from it to another table from another
>source, so I can query from both. Each has a field that contains an unique
>ID number, although the linked table has leading zeros in that field so that
>each ID is 8 numbers, and the other table stores them as they are without
>leading zeros.
>
>No luck in finding help with my Access manual (or at least I may not know
>enough to find it) and what I find online talks about how to link and I want
>to know how to unlink a protected table so I can work with it.
>
>Any help appreciated. Thanks.[/color]

[Wayfarer]

Re: How to unlink a protected table?

Thank you Jack!

It will make a difference for me because I also need to be able to update
information such as incorrect phone numbers. So thank you very much for
taking time to help!

--
Marta
(if you email me directly you need to remove the X )

"Jack MacDonald" <jackMACmacdona ld@telus.net> wrote in message
news:uq09109i4u fks11tmel19eoc6 4fmlp70nd@4ax.c om...[color=blue]
> Not really sure what difference it makes whether the table is linked
> -- I suspect it makes no difference. This SQL will query both tables:
>
> SELECT tblWithNumericK eyfield.Numeric Field,
> tblWithNumericK eyfield.SomeOth erInfor, tblWithTextKeyf ield.TextKey,
> tblWithTextKeyf ield.SomeValue
> FROM tblWithNumericK eyfield INNER JOIN tblWithTextKeyf ield ON
> tblWithNumericK eyfield.Numeric Field =
> val(tblWithText Keyfield.TextKe y);
>
>
> Modify the table names and field names as appropriate for your tables.
>
>
> On Sun, 25 Jan 2004 20:20:29 GMT, "Wayfarer" <Wayfar1X@swbel l.net>
> wrote:
>[color=green]
> >I have a table given me as "linked" table, which means I can not change
> >anything. There are 135621 rows and 50 fields, and there was no Primary
> >Key designated.
> >
> >I want to to able to link one field from it to another table from another
> >source, so I can query from both. Each has a field that contains an[/color][/color]
unique[color=blue][color=green]
> >ID number, although the linked table has leading zeros in that field so[/color][/color]
that[color=blue][color=green]
> >each ID is 8 numbers, and the other table stores them as they are without
> >leading zeros.
> >
> >No luck in finding help with my Access manual (or at least I may not know
> >enough to find it) and what I find online talks about how to link and I[/color][/color]
want[color=blue][color=green]
> >to know how to unlink a protected table so I can work with it.
> >
> >Any help appreciated. Thanks.[/color]
>[/color]