Original Post
Hey, I am using ADO.net to insert/delete data in my Access database in a program I have. I am also using the OleDbCommandBuilder to automatically generate the INSERT/DELETE/UPDATE commands. The problem is: When I am trying to insert a row into one of my tables, it says "Dynamic SQL generation can not be used on multiple base tables". I believe this is because the table I am trying to insert a row into, has a foreign key in it that comes from a different table. I presume that is what the error means by 'multiple base table'. I'm not exactly sure but I guess the problem is with the OleDbCommandBuilder. My first question is: do most people use the CommandBuilders to generate the sql commands automatically? Secondly, if I don't use the CommandBuilder, how exactly do I insert the row and have it updated into my actual Access database. Do I have to set the InsertCommand property of my DataAdapter for every table and then do something with that? Thanks for the help. If you know how to fix the issue with 'multiple base tables' and my CommandBuilder, that also would be great. Thanks