Newbie_Tables_&_Relationships

[JRodriguez]

I am teaching myself to create a DB in order to track the logistics of trailers for my company.



When creating tables I selected the wrong data types. When I attempt to change some of the Data Types I get the following msg

You can't change the data type or field size of this field; it is part of one or more relationships.

If you want to change the data type of this field, first delete it's relationships in the Relationships window.

I've deleted Relationships in the Relationships window but still cannot change the data type.

I'm sure this is something easy for someone who knows what they are doing. Any help will be valued and appreciated.

[llkhoutx]

You cannot change some datatypes when the table column is populated with data.

[JRodriguez]

There are no data in the tables at this point. Should I just re-create the tables?

[llkhoutx]

Fields in different tables must generally be of the same datatype. Maybe you're attempting to change the datatype of a field linked to another table.

How did you delete the relationships in the relationship window. Click the "All Relatonships" icon in the relationships window to be certain your delete was effective.

To delete a relationship, right-click the relationship (line) between two tables and a window will popup giving you two options, "Edit Relationship" or "Delete Relationship." Of course, select "Delete Relationship."

If your table is a parent table, that is, has children, you cannot delete the table. So merely rebuilding the table may not be an option.

[JRodriguez]

Thank you very much for your help!

[Microsoft Access Database]

When you delete the relationships make sure you save the changes. Also for certain data type you will not be able to change the type if you have data held. You could create a brand new table with the correct data types and then copy and paste the data from the old table. Otherwise use an append query.

[JRodriguez]

thank you all very much!!!