title: Setting decimal places in an MDB database
body: <p>Part of a project I am working on is programmatically create a series of MDB files which will be the final deliverables. The specs from the client ask for some fields in the tables to have 3 decimal places.</p>
  
  <p>I create the mdb files using python at first, and then to be able to alter the columns to DECIMAL (10,3), I use ADODB (C#, .NET 4.0) - as i couldn't find something suitable in Python. Problem though is that this will not be enough for the client. They want to open the MDB and in Design Mode to see the Decimal places for these fields to be set to 3. If they are not, the file is not accepted.</p>
  
  <p>It has now taken me the best part of 3 days trying to come up with a solution. One likely candidate was DAO and the Field2 object but this object has so far eluded me. I am using the Microsoft DAO 3.6 Objects but Field2 doesn't seem to be part of the assembly. And dont even know if this will actually do what is required...</p>
  
  <p>Does anyone know a way to do this? Don't care if its DAO, ADO, OLEDB or any other 3 letter acronym to be honest? How can I get from this:</p>
  
  <p><img src="https://i.stack.imgur.com/Psin6.png" alt="enter image description here"></p>
  
  <p>to this - PROGRAMMATICALLY??</p>
  
  <p><img src="https://i.stack.imgur.com/xnVUg.png" alt="enter image description here"></p>