field names compatibility

[Paul M]

Hi
I am using frontpage 2003 connected to an access 2003
database. when you construct a table in access it allows
you to leave spaces in the field names,but when you try
to use these field names in frontpage to create a results
search page it won't allow you to use spaces in field
names. is there a way around this.
Paul M

 

[Bob Lehmann]

You can put [] around the field name - [Field Name]. Or you could do the
right thing, and properly name your DB fields.

Just because Access allows you to do something, that doesn't mean it's a
good idea.

Bob Lehmann

 

[Murray]

And, in this case it's an especially bad idea....

--
Murray

You can put [] around the field name - [Field Name]. Or you could do the
right thing, and properly name your DB fields.

Just because Access allows you to do something, that doesn't mean it's a
good idea.

Bob Lehmann

Hi
I am using frontpage 2003 connected to an access 2003
database. when you construct a table in access it allows
you to leave spaces in the field names,but when you try
to use these field names in frontpage to create a results
search page it won't allow you to use spaces in field
names. is there a way around this.
Paul M

 

[Bob Lehmann]

A clarification....
In your code, you can put [] around the field name - [Field Name].

Bob Lehmann

You can put [] around the field name - [Field Name]. Or you could do the
right thing, and properly name your DB fields.

Just because Access allows you to do something, that doesn't mean it's a
good idea.

Bob Lehmann

Hi
I am using frontpage 2003 connected to an access 2003
database. when you construct a table in access it allows
you to leave spaces in the field names,but when you try
to use these field names in frontpage to create a results
search page it won't allow you to use spaces in field
names. is there a way around this.
Paul M

 

[Guest]

Thanks Bob

-----Original Message-----
You can put [] around the field name - [Field Name]. Or you could do the
right thing, and properly name your DB fields.

Just because Access allows you to do something, that doesn't mean it's a
good idea.

Bob Lehmann

Hi
I am using frontpage 2003 connected to an access 2003
database. when you construct a table in access it allows
you to leave spaces in the field names,but when you try
to use these field names in frontpage to create a results
search page it won't allow you to use spaces in field
names. is there a way around this.
Paul M

.