DrZoo
DrZoo
Programming language:VBA
2021-03-17 03:49:11
0
Q:

ADOX.Column adBoolean

asianirish
asianirish
Code: VBA
2021-07-30 21:01:20 
'To add to an ADOX table a column of type adBoolean 
'the Attributes property MUST NOT be set to adColNullable.

'This will cause a:
'Run-time error '-2147217887 (80040e21)':
'Multiple-step OLE DB operation generated errors. Check each OLE DB
'status value, if available. No work was done.

'And the Boolean column will NOT be appended to the table.

'The solution is to set the column Attributes property to one of the 
'two following values:
.Attributes = 0	'Default Attributes property value
.Attributes = 1	'adColFixed

'Again, an adBoolean column cannot have the following Attirbutes
'property value. This will raise the Run-time error above:
.Attributes = 2	'adColNullable
1

Related

New to Communities?

Join the community