I inherited a MS Access database. One of the columns in a table happened to name with a SPACE in the middle, "FrameMaker Location". I know, it's not a smart way to name a column.
I was trying to insert some new records into the table. It only worked when I removed the SPACE from the column name (from my code and DB), like "FrameMakerLocation". Otherwise, I got an error like this "Syntax error in INSERT INTO statement".
Do you know any tricks so that I don't have to rename the column name???
Thanks so much in advance
Have a great Thur.
Here is my draft of code (roughly)
DataRow row = dataSet.Tables.NewRow();
row["FrameMaker Location"] = sFrameMakerLoc;
iNumOfAffectedRecs = adapter.Update(dataSet);