Should I delete the old ACWZURS12.ACCDU folder? I have backed it up aswell. Do you mean hide all the folders again?
I always show hidden files etc. Just because they are hidden does not mean they are not used."Don't show hidden files, folder or drives".
If you are linking two fields of similar data type such as TEXT then the size of the field should be equal. Use 255 with 255, 50 with 50 etc but never 50 with 5.
Hi PlayMisty, sorry I have been busy. What do you want me to send? The table I sent before?
https://support.office.com/en-nz/article/Set-the-field-size-ba65e5a7-2e6f-4737-8e72-36b93f966a33
says in part, "You can also change the field size of a field that stores text data, although this action has a smaller effect on the amount of space that is used." So I think it's better just to leave them at the default size of 255. If you need to you can limit the users input with masks on the forms.
If you change all you fields to 255 you will avoid any problems in relationships that Play Misty seems to be concerned about.