Turn off special meaning of ( ) brackets.

[steve]

I'm trying to run an append query.
When I run it I get the following error.

The INSERT INTO statement contains the following unknown field name:
'Memory(MB)'. Make sure you have typed the name correctly, and try the
operation again.

The actual name of the field is Memory (MB) , please note that there is
a space between the y and ( .

While I understand that it would be a lot simpiler if I had no space
and no bracket ( ) . This is what I have.

In the query design view, there is the following.

Field : Memory (MB)
Table :tmptblNewImportLogfile
Apend To : Memory(MB)

The obvious offending setting is Memory(MB) with no space between y and
(
Its seems sometimes when I put a space between the y and ( it sometimes
stays then disapears to Memory(MB) no space again. IM not sure what the
solution is, but is there a way I can add a space to explicitly eg " "
or ' ' I have tried both but they dont seem to work.

Can anyone provide any answers to this.

Regards

steve

7willie

 

[Dirk Goldgar]

I'm trying to run an append query.
When I run it I get the following error.

The INSERT INTO statement contains the following unknown field name:
'Memory(MB)'. Make sure you have typed the name correctly, and try the
operation again.

The actual name of the field is Memory (MB) , please note that there
is a space between the y and ( .

While I understand that it would be a lot simpiler if I had no space
and no bracket ( ) . This is what I have.

In the query design view, there is the following.

Field : Memory (MB)
Table :tmptblNewImportLogfile
Apend To : Memory(MB)

The obvious offending setting is Memory(MB) with no space between y
and (
Its seems sometimes when I put a space between the y and ( it
sometimes stays then disapears to Memory(MB) no space again. IM not
sure what the solution is, but is there a way I can add a space to
explicitly eg " " or ' ' I have tried both but they dont seem to work.

Can anyone provide any answers to this.

Does this work?

Field : Memory (MB)
Table :tmptblNewImportLogfile
Append To : [Memory (MB)]

 

[steve]

Thanks Dirk.

 

['69 Camaro]

Hi, Steve.

While I understand that it would be a lot simpiler if I had no space
and no bracket ( ) . This is what I have.

You found out that enclosing the offending column name in brackets helped Jet
"fix" the name. In the future, if you use only alphanumerics and the underscore
for names, you can avoid this problem. If you also use the Caption Property,
users will see "Memory (MB)," even if the name is actually "MemoryInMB."

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.