Query Column names with spaces in MS ACCESS

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 427,935 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,962 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 1349 | Replies: 2

•

Join Date: Feb 2008

Posts: 112

Reputation: dinilkarun is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

dinilkarun dinilkarun is offline

Offline

Junior Poster

Query Column names with spaces in MS ACCESS

Jul 22nd, 2008

we are able to query successfullu from a Column called "ParentUUD" (without space) using query

"SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'"

we have a column whose name is "Parent UUID" (with space)
We are trying to query the column from PYTHON. we are getting error.I think the error is due to space in the column name.

Please tellus the method to query the MS access DB with column names with spaces.

•

Join Date: Jan 2008

Posts: 29

Reputation: boblarson is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

boblarson

Offline

Light Poster

Re: Query Column names with spaces in MS ACCESS

Jul 22nd, 2008

Encapsulate the field name in square brackets

[Parent UUID]

and in the future do not use spaces in field or object names as it simplifies things if you don't.

Bob Larson
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development