Problems with table fields

  • Thread starter Thread starter Teofilo Homsany
  • Start date Start date
T

Teofilo Homsany

Hi!!
I am building a web interface application for an already working application
created for a company using Access tables.
The problem I'm having is that this company created long table fields, for
example 'Name of business' instead of 'nameofbusiness' or 'name_of_business'
which is more helpful.
Now I'm trying to integrate the DB with coldfusion to run some reports and
I'm finding out that I can't query long field names.
Does anyone have an idea on how I can accomplish running a query using long
field names? I can't rename the field names cause the program is already up
and running and it was done by another company.

Thanks much in advance,
Teo
 
I dont know y u could use the names as is but try wrappin
brackects around the names...If im not mistaken even in MS
Access if you highlight a table or query with spaces in
the name then click Insert | Query and look at it in SQL
View brackets will b around the name...
 
Back
Top