Database Connectivity Toolkit Create Table Column header characters

[Beach_Comber]

Hi All,

I am using the Create Table Example.vi and find that it will not allow characters other than alpha-numeric for column header names.  If I open Access and use design view and use many characters like (), /, [], etc Access accepts the input.

I am wondering if there is a work around for this problem.

regards,

Karl

[falkpl]

I have not tried this in access (I always use alpha-numeric charaecter for column headers) but often to use illegal characters in programming excape clauses are provided (usually \ proceeding the illegal character)  you should check your access programming docs.

[Brinoceros]

The escape in Access is brackets: [special_char].  Microsoft supplies some information on this, including known issues with special characters on this website.  The main point here is really to try to avoid special characters.

This KnowledgeBase article more specifically addresses this issue you are running into with LabVIEW. 

I hope this helps!

[falkpl]

Good to know, I will save this for when I need it (I am sure I will).  I am using more and more databases in my applications.