VB.NET - Ms-access - Error - "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

[sivakumar mariappan]

Hi, I have created the table structure and added the composite primary keys to the ms-access table using VB.NET. while the control crosses the line "ADOXtable.Columns("CHARX_VALUE_COL").Properties("Nullable").Value = False", an error message raised as "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." ADOXtable = New ADOX.Table ADOXtable.Name = "ACN_CHARX_INSTANCE" ADOXtable.Columns.Append("LOGICAL_DB_NAME", ADOX.DataTypeEnum.adVarWChar, 32) ADOXtable.Columns.Append("DIM_NAME", ADOX.DataTypeEnum.adVarWChar, 32) ADOXtable.Columns.Append("CHARX_NAME", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("CHARX_TABLE", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("CHARX_VALUE_COL", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("VALUES_UNIQUE", ADOX.DataTypeEnum.adInteger) ADOXtable.Columns.Append("CHARX_ORDER_COL", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("CHARX_ORDER", ADOX.DataTypeEnum.adInteger) ADOXtable.Columns.Append("CHARX_NUMERIC_COL", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("BITMAP_COL", ADOX.DataTypeEnum.adVarWChar, 128) 'append tables to database cat.Tables.Append(ADOXtable) key1.Name = "PrimaryKey" key1.Type = ADOX.KeyTypeEnum.adKeyPrimary key1.Columns.Append("LOGICAL_DB_NAME") key1.Columns.Append("DIM_NAME") key1.Columns.Append("CHARX_NAME") key1.Columns.Append("CHARX_TABLE") ADOXtable.Keys.Append(key1) ADOXtable.Columns("CHARX_VALUE_COL").Properties("Nullable").Value = False ADOXtable.Columns("VALUES_UNIQUE").Properties("Nullable").Value = True ADOXtable.Columns("CHARX_ORDER_COL").Properties("Nullable").Value = True ADOXtable.Columns("CHARX_ORDER").Properties("Nullable").Value = True ADOXtable.Columns("CHARX_NUMERIC_COL").Properties("Nullable").Value = True ADOXtable.Columns("BITMAP_COL").Properties("Nullable").Value = True Please provide your valuable comments. Thanks, Sivakumar.M.

[Dave Kreskowiak]

I would take that you mean that you have to commit the new columns to the database before you attempt to modify them and make the column nullable.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008