Disappearing Relationships due to Windows Update?

[taw]

Hi all,

I think I have this figured out, but wanted to see if anyone else had run into the same thing.

I keep each of my client's databases in separate folders named after their respective company. One of them has an apostrophe in the name and I have it named that way and have never had a problem with it. I had copied a front and back end mdb from their office and reloaded it on my computer to make some changes and got a strange error. When I went to check the relationships, there were none. I checked a previous copy of the program and the relationships were all showing correctly. I went back to their office and got another copy of the program, copied it back to a temp folder on their computer and found that the relationships were ok. But when I loaded the files here, they weren't there.

In the end, it was the apostrophe in the folder name that caused the problem and it occurred to me that Windows had updated the other day. Has anyone else had this happen? I guess I learned another lesson about naming anyway.

Tom W.

 

[ghudson]

You should always avoid special characters when ever you name an object or file.