By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,798 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

How to unlink a protected table?

P: n/a
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 )
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.


Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.