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

autonumber->number of key

P: n/a
Hi I have a table STUDENTS with key (autonumber) StudentId.
Studentid is a lookup column in other tables and forms
I want to make it number. When I try, I get "you can't change the data
type or field size of this field; it is part of one or more
relationships"
A way I thought of to bypass this is :
1. delete the table and thus all the relationships
2. paste the table from a backup of the .mdb I have
3. change the type

Now there are 2 issues:
A. I think the relationships do not hold anymore. I infer that because
if i try to delete the table once more, it does not tell me that its
relationships will be deleted.

B. Also, if I rename the table, it is not renamed in all queries, and
lookup columns it is used.

About B, I thought to open all queries and tables and just save them so
that "auto-rename" will work when I want to rename the table.

I thought to do the same for A, but the relationships are still not
recreated (because if I try to delete the table I get no warning).

To cut the long story short, is there a way to make this field from
autonumber->number and retain all relationships and the "auto-rename"
feature ?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"interuser" <in*******@hotmail.com> wrote
Hi I have a table STUDENTS with key (autonumber) StudentId.
Studentid is a lookup column in other tables and forms
I want to make it number. When I try, I get "you can't change the data
type or field size of this field; it is part of one or more
relationships" [snip] Now there are 2 issues:
A. I think the relationships do not hold anymore. I infer that because
if i try to delete the table once more, it does not tell me that its
relationships will be deleted.

B. Also, if I rename the table, it is not renamed in all queries, and
lookup columns it is used. [cutting long story short] To cut the long story short, is there a way to make this field from
autonumber->number and retain all relationships and the "auto-rename"
feature ?


It sounds like you have deliberately or accidentally deleted some but not
all of the relationships that table STUDENTS participates in.

1. In the Relationships Window, go through the entire list of tables and
show all of them. Make sure you don't miss any.

2. Delete any relationships to table STUDENTS.

3. Change the field type from number to Long

4. Reconnect the relationships.
Darryl Kerkeslager
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.