Solved

MySQL MS Access / Northwind Template

Posted on 2014-01-30
1
587 Views
Last Modified: 2014-02-17
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
Comment
Question by:Brogrim
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now