UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Escaping special characters in server name (MS-Query)    
 
   
dflak
post Apr 26 2007, 12:43 PM
Post #1

Utter Access VIP
Posts: 3,548
From: North Carolina



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.
Go to the top of the page
 
+
Luceze
post Apr 26 2007, 12:46 PM
Post #2

UtterAccess VIP
Posts: 2,601
From: Dallas, Texas USA



Use the IP address of the server instead of the UNC path.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 10:14 AM