problem with the column name which is a reserved word 1

[poporogue]

there is one columne name in the database called "section", and when i use a sql to run a query in vba, it occurs errors. i found that "section" is a reserved word in vba. so when i change the "section" to "section1", there is no errors then.
the problem is, i could not change the colume name from "section" to "section1" because there is already a system running with this db. so i can't change the column name, it will affect the running system.

so what can i do to solve this problem?

 

[BillPower]

Hi poporogue,

In your SQL Statement try placing Section in Square Brackets like this: [Section].

Just a thought.

Bill

 

[poporogue]

oh~~thx
you are so helpful.
my problem is solved~
thx again

 

[JeremyNYC]

poporogue,

Give Bill a star. That's what they're there for. Just click on "Mark this post as a helpful/expert post!"

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.