Access 97 Table Name

Article View: borland.public.cppbuilder.database.ado

Article #5314

Back to borland.public.cppbuilder.database.ado Previous Next

#5314

From: Lee Gan
Date: Wed, 20 Jun 2001 19:52

12 lines
1466 bytes

I use ADO to access an MS Access 97 database. The table I am accessing has a
name like this: "a:aaa:aa:aaaa" where "a" is a char. The problem is if I use
an SQL statement like "SELECT * FROM a:aaa:aa:aaa WHERE ...", the program
will interpret the table name a:aaa:aa:aaaa as a sequence of parameters
because of the ":" within the table name. So what I did was first, create a
query which copies the contents of a:aaa:aa:aaaa but whose name does not
contain the ":", and then do "SELECT * FROM QueryName WHERE ...".

My question is: Does anyone know of an alternative solution without creating
a dummy query? Many thanks,

Lee

Technical Details

Message-ID: <3b30feed$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5a793e13b2e06fa2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-20 13:13:40 PST
From: "Lee Gan" <leegan@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Access 97 Table Name
Date: Wed, 20 Jun 2001 13:52:13 -0600
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 207.34.102.197
Message-ID: <3b30feed$1_1@dnews>
X-Trace: dnews 993066733 207.34.102.197 (20 Jun 2001 12:52:13 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews