开发者

ms access can't edit field because I must delete relationships but there are no relationships to delete

开发者 https://www.devze.com 2022-12-08 17:34 出处:网络
I have built a database on multiple tables.One of these tables has a field (Initials) that was originally defined to have 50 characters.After building the entire thing I realize I would have liked tha

I have built a database on multiple tables. One of these tables has a field (Initials) that was originally defined to have 50 characters. After building the entire thing I realize I would have liked that field to be limited to 3 characters. I tried to change this, but it tells me that I have to delete one or more relationships. So, I open up the relationship window and delete the one relationship that is attached to this field, expecting that I should be able to go back and change the character limit then go back and add the relationship again. So, as of now there are ABSOLUTELY NO relationships touching Initials in the relationships window. I go back to change the char limit and it gives me the same error. I can't even delete Initials and recreate it because of the same error. I went through my entire project and took that开发者_Python百科 field out wherever it appeared. Still, same error. Any ideas?


Per Matt,

apparently when you display a field in a report it does not show up in the relationships >window. I deleted it from the report, edited the char limit, then put it back in the >project. of course, right when i resort to the forum i figure it out. thanks to those who >helped

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号