I used dbTools to do a DAO import into MySQL of a Microsoft Access database. It creates a datetime column that I change to date, because I don't think a datetime field works with dbforms.
Some of the rows have null values in this date column. This is not a mistake, the values were null in MS-Access and I want them to be null in MySQL.
It seems that unless I delete the rows containing the null date values, dbforms will not work. How do I make nulls in a date field scceptable for dbForms?
Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I found out that using dbTools to import data from MS-Access to MySQL somehow locked-up MySQL such that dbFOrms could not access the tables. As soon as I shutdown and restarted MySQL, the problem disappeared, as well as many other problems I've been having.
I hope that this experience helps someone else.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I used dbTools to do a DAO import into MySQL of a Microsoft Access database. It creates a datetime column that I change to date, because I don't think a datetime field works with dbforms.
Some of the rows have null values in this date column. This is not a mistake, the values were null in MS-Access and I want them to be null in MySQL.
It seems that unless I delete the rows containing the null date values, dbforms will not work. How do I make nulls in a date field scceptable for dbForms?
Thanks.
I found out that using dbTools to import data from MS-Access to MySQL somehow locked-up MySQL such that dbFOrms could not access the tables. As soon as I shutdown and restarted MySQL, the problem disappeared, as well as many other problems I've been having.
I hope that this experience helps someone else.