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]

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 tblWithNumericKeyfield.NumericField,
tblWithNumericKeyfield.SomeOtherInfor, tblWithTextKeyfield.TextKey,
tblWithTextKeyfield.SomeValue
FROM tblWithNumericKeyfield INNER JOIN tblWithTextKeyfield ON
tblWithNumericKeyfield.NumericField =
val(tblWithTextKeyfield.TextKey);
Modify the table names and field names as appropriate for your tables.
On Sun, 25 Jan 2004 20:20:29 GMT, "Wayfarer" <Wa******@swbell.net>
wrote:

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.

[Wayfarer]

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" <ja**************@telus.net> wrote in message
news:uq********************************@4ax.com...

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 tblWithNumericKeyfield.NumericField,
tblWithNumericKeyfield.SomeOtherInfor, tblWithTextKeyfield.TextKey,
tblWithTextKeyfield.SomeValue
FROM tblWithNumericKeyfield INNER JOIN tblWithTextKeyfield ON
tblWithNumericKeyfield.NumericField =
val(tblWithTextKeyfield.TextKey);
Modify the table names and field names as appropriate for your tables.
On Sun, 25 Jan 2004 20:20:29 GMT, "Wayfarer" <Wa******@swbell.net>
wrote:

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 uniqueID number, although the linked table has leading zeros in that field so thateach 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 wantto know how to unlink a protected table so I can work with it.

Any help appreciated. Thanks.