My company has a sub for updating an access database table with a dataset. We pass it a SQL Select statement which then in the sub updates the DataAdapter using OleDb.OleDbCommandBuilder(TheDataAdapter)
this has been working fine for 2 years now, until now, one of the tables that needs to be updated in the database has 2 columns that have a space in the name. Getting the data is fine, we simply put brackets "" around the fields (columns) that have a space and it pulls all the data just fine, but the OleDb.OleDbCommandBuilder removes the bracket's when it generates the Delete and Insert statements which causes and error when the dataadapter's Update() method gets called.
Is there a way around this?
here's the class info: http://msdn2.microsoft.com/en-us/lib...r_members.aspx