Someone in his infinite wisdom named one of our servers Ft. Worth. Yes, there is a period after the "Ft".
Grammatically, this is in correct. It is OK to abbreviate "fort" if you mean a military installation, but it should always be spelled out in city names. However, that's not the problem.
I have a database called db1.mdb here and a query therein called qry_one. It is to qry_one that I want to link. Since not everybody has their drives mapped the same way I do, I have to give the full path name when MS-Query asks me for the database name.
So I type in \\Ft. Worth\db1.mdb, and it works until I try to save the query when I get an invalid bracketing error telling me that it can't find query Worth in database Ft.
The period after the Ft needs to be escaped so it is not confused with a file extension.
In the Unix world, the backslash (\) was the universal escape character, but it obviously won't work here.
I tried enclosing the whole thing in single quotes and double quotes and get the error message that the file is not found.