<div>
<div class="content wysiwyg-content">
I downloaded the Northwind template from MS Access 2010. <br />
<br />
I then recreated all the tables on MySQL Workbench CE 5.2. I am having a problem with the &quot;Purchase Order Details&quot; table. The column in MS Access is Yes / No so I created a a column with a datatype tinyint(1) <br />
<br />
<a href="http://fonlow.com/dbconverters/mysql2access_matrix.html" rel="ugc">http://fonlow.com/dbconverters/mysql2access_matrix.html</a><br />
<br />
When I try and run the program it is crashing when I try to &quot;Add to Inventory&quot; after confirming a purchase order. The column is &quot;Posted to Inventory&quot;.<br />
<br />
Any Ideas, I have numerous scripts for Northwind MySQL but they seem to &nbsp;be an older version
</div>
</div>


I downloaded the Northwind template from MS Access 2010. 

I then recreated all the tables on MySQL Workbench CE 5.2. I am having a problem with the "Purchase Order Details" table. The column in MS Access is Yes / No so I created a a column with a datatype tinyint(1) 

http://fonlow.com/dbconverters/mysql2access_matrix.html

When I try and run the program it is crashing when I try to "Add to Inventory" after confirming a purchase order. The column is "Posted to Inventory".

Any Ideas, I have numerous scripts for Northwind MySQL but they seem to  be an older version

MySQL MS Access / Northwind Template

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.