Re: Spaces in table names

From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
Date: Thu, 24 Aug 2006 21:46:22 -0500

D7, ADO, Access
Is there a syntax that will allow me to use an Access table with one or more
spaces in the name? I have tried enclosing the table name in " " and in [ ]
to no avail.

For most context having the table name in [ ] should work.
e.g.
Select * from [Stupid Table Name]

What are you trying to do?
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Follow-Ups:
- Re: Spaces in table names
  - From: Bob Berry

References:
- Spaces in table names
  - From: Bob Berry

Prev by Date: Re: Ado Password Question
Next by Date: Error (path could not be found)
Previous by thread: Spaces in table names
Next by thread: Re: Spaces in table names
Index(es):
- Date
- Thread

Relevant Pages

Re: LoadFromFile problem
... for SQL sever the syntax is like this. ... Brian Bushay (TeamB) ...
(borland.public.delphi.database.ado)
Re: syntax spec. for C ?
... (The syntax listed under the "C Syntax" page, ... will have to be gleaned from context. ... Declarations, Definitions and Types ... Phrase Structure Rule Comment ...
(comp.compilers)
Re: No exceptions?
... substituting TABLE_DUM for x in the expression "x join y" when x is not ... named x, so given that the syntax insists x is a relation, it must be the same relation as either TABLE_DEE or TABLE_DUM ... My understanding of the CWA in practice is that by convention we record all true facts and we don't record false facts, in TTM style, we might record z by saying 'z:= ', if we knew just exactly what 'sometype' stood for - it could stand any of many types, eg. integer, string or even relation so it's not clear how to record it. ... specified type to have its type inferred from context - in this case I'd say the context comes from the definition of y, ...
(comp.databases.theory)
Re: Tech directions for Delphi?
... Your two examples don't deal with context (what task is that you're running? ... The syntax also refers to a procedure/method call, rather than compiler support, meaning you cut yourself from a variety of coding simplifications and execution optimizations. ... The smaller the tasks, the easier the balancing, and the more cores you can make use efficiently with the same codebase. ...
(borland.public.delphi.non-technical)
Re: help with syntax contexts - confused
... the same context as the macro call (that is stx). ... is a syntax object representing a list of symbols - and not a ... I found that while my original solution works for the lambda1, ...
(comp.lang.scheme)