Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 639
  • Last Modified:

MySQL MS Access / Northwind Template

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
0
Brogrim
Asked:
Brogrim
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have to wonder why you're using MySQL with the NorthWinds database ... SQL Server Express is free, and there's a SQL version of NorthWinds.

Are you setting this column on a form, or through a query, or through code?

If through code, can you show the code you're using?
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now