Spaces in table names for use with asp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherited an Access database which has spaces in table names - do I need to get rid of the spaces before using the db with asp? If not how do I handle them
 
My advice would be to rename all of the tables and fields to eliminate the
spaces.

If that's not possible, using square brackets around the names should work:

SELECT [Field 1], [Field 2] FROM [My Table]

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


KBrad said:
I have inherited an Access database which has spaces in table names - do I
Click to expand...
need to get rid of the spaces before using the db with asp? If not how do I
handle them?
 
Agreed. It's a nice "feature" until 3:00 AM and you try to find "this
field" instead of "This field"

Douglas J. Steele said:
My advice would be to rename all of the tables and fields to eliminate the
spaces.

If that's not possible, using square brackets around the names should work:

SELECT [Field 1], [Field 2] FROM [My Table]

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


KBrad said:
I have inherited an Access database which has spaces in table names - do
Click to expand...
I
need to get rid of the spaces before using the db with asp? If not how do I
handle them?
Click to expand...
 
Back
Top