Re: Spaces in table names

[Table name] and `Table name` should work for Access. Note that in second
case ` is not single quote.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Bob Berry" <callbob@xxxxxxxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:44edde19@xxxxxxxxxxxxxxxxxxxxxxxxx
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.




.

Relevant Pages

  • RE: [Info-ingres] Migration
    ... I have a syntax problem with IngresII ... statements are using the sql string delimiter single quote instead of the ... Also the copy statements are in SQL syntax. ...
    (comp.databases.ingres)
  • Sproc parameter: escaping character
    ... Let's say I'm trying to execute a stored procedure by calling 'Exec'. ... the syntax highlighting is just fine in query analyzer. ... "Unclosed quotation mark before the character string ''." ... So why doesn't escaping the single quote work in this case, ...
    (microsoft.public.sqlserver.programming)
  • Re: Macro to VB
    ... ampersand is concantenate and a single quote is a comment, ... I intended to use the docmd as a part of an If ... in the If command. ... How do I change the syntax to make this ...
    (microsoft.public.access.modulesdaovba)
  • Re: Hard Code a existing SQL query!!! HELP solicited
    ... You are correct with the syntax ... specified and I could figure out the single quote syntax!! ... "dialect" of SQL for MS SQL Server and the Jet DB Engine that is the default ... Microsoft Access MVP ...
    (comp.databases.ms-access)