Access Table Column naming problems.
Hi,
I have just struggled with an Access updating problem which gave me the error "Syntax error in Insert Command"
The cause turned out to be that some characters which are permitted by Access in the naming of table columns are NOT permitted when using VB.NET. I don't know how many characters fall into this category but my problem was caused by the use of "(". I had a column named "RAM(Gb)" and I had to change it to "RAM".
Also the use of "-" is NOT permitted but the use of "_" is.