On Thursday 13 March 2003 20:27, Steve Holt wrote:
> I am linking an MS Access front end to MYSQL on the back with ODBC
> If I open the table I can enter a value in the course name field only which
> is the primary key
> and it will save the record even though I have not entered values in the
> fie
NOT NULL does not mean you can not leave the field empty.
It means the field can not contain the value NULL
All the empty fields get the default values you declared.
If you did not declare a default value, standard default values
for each data type are used.
Steve Holt wrote:
I am linking an MS Ac
I am linking an MS Access front end to MYSQL on the back with ODBC
If I open the table I can enter a value in the course name field only which
is the primary key
and it will save the record even though I have not entered values in the
fields set up as NOT NULL
I have an ODBC trace file but it see
You have to show us.
Steve Holt wrote:
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered` (
`DateCourseCreated` datetime default NULL,
`Specialty` int(25) NOT NU
