Access says a relationship exists when there are non - help!

G

Guest

In MS Access, I am trying to change the data type of a field from number to
text. However, Access says I cannot do it because there is a relationship
set up. I have deleted all relationships, restarted several times and
fiddled a lot, yet Access keeps saying that I have a relationship and won't
let me change the data type. If anyone can help, it would be much
appreciated. thanks!
 
G

Guest

Click on TOOLS - Relationships and Show All. If it is not showing then use
the TOOLS - Analyze - Documentor. Select your table and in Options select
relations. Also in queries select all and in Options select relations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disappeared Relationships; Can't Recreate 2
Can't change data type 2
Please help: edit relationship type 13
Exporting query to table in external database 4
Relationship must be on the same number of fields with the same... 9
newbie can't edit relationship type... 1
Relationships in access 2004 5
You can't change the data type or field size of this field error. 2

Top