Access 2002 Problem

[Bob B]

I am trying to change the data type of a foreign key in Access 2002 to a Lookup wizard and it keeps telling me that I have to remove the relationships before I can do this. It works fine in Access 2000 but will not work in Access 2002.

Any ideas? I can't believe I would have to remove Relationships in order to change a data type?

Bob

 

[Allen Browne]

You will need to remove the relation, and change both the primary key and
the foreign key and then build the relation again. Otherwise the relation
would be between incompatible data types/sizes at some points during the
change over.

The issue you raise has nothing to do with the Lookup wizard in table design
really, but I would point out that many of us hate this wizard since it
hides the actual values your table is storing and makes it more difficult
for you to understand what is really going on between your tables.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am trying to change the data type of a foreign key in Access 2002 to a
Lookup wizard and it keeps telling me that I have to remove the
relationships before I can do this. It works fine in Access 2000 but will
not work in Access 2002.

Any ideas? I can't believe I would have to remove Relationships in order to
change a data type?

Bob

 

[Bob B]

Why would this have been changed from Access 2000 to 2002? It worked fine
with 2000?

 

[Allen Browne]

To change the data type of a foreign key field in a relationship with
relational integrity has required breaking the relation since Access version
1.

 

[Bob B]

Not to be picky but I found you can do it through the Lookup tab, you just
can't use the wizard to make it. Very strange.

 

[Larry Linson]

Frankly, I do not use Lookup Fields -- they obscure what is actually in the
field and make subsequent maintenence more difficult. They are helpful to
the novice end-user, but only until they need to use the table in queries.
I'd wonder why you would want to change a foreign key to a lookup field.

Larry


I am trying to change the data type of a foreign key in Access 2002 to a
Lookup wizard and it keeps telling me that I have to remove the
relationships before I can do this. It works fine in Access 2000 but will
not work in Access 2002.

Any ideas? I can't believe I would have to remove Relationships in order to
change a data type?

Bob

 

[Bob B]

It is for school. The book we are using is written for Access 2000 but I am
using Access 2002 at home. I figured out that in Access 2002 you can delete
the relationship and it will re-create it when you create the look-up
wizard.

Thanks.