Un-link a table

[Jacob-Bushnell]

Here is what I am trying to do.

Open a table in design view, to change the data type in one field from “text” to “number”

The problem is the table is “linked” and I can’t seem to figure out how to “unlink it”

Help.

 

[namliam]

Goto to the relationship window and remove the link...
From the database window:
Tools=> Relationships

Note however that you will have to change all linked fields as well to be able to restore the link

Regards

The mailman

 

[Pat Hartman]

You need to change the linked table by opening the db that contains it and changing it there. It is not necessary to remove relationships unless there is one on the field you need to change.

 

[Jacob-Bushnell]

Thanks a lot every one! I fianly got my DB off to the printers.
You all are a big help