Hi,

I converted my Access DB file to MySQL by exporting the tables. However, the tables exported, all fields are NULL enabled.

Is there a way I can force it to be NOT NULL for all fields or is there any tools available to do the conversion?

I tried changing 1 by 1, but sometimes an error prompted, "ALTER TABLE 'db1'.'table1' MODIFY COLUMN 'col1' VARCHAR(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';

MySQL Error Number 1265
Data truncated for column 'team' at row 724.

And, if the fields are not set to NOT NULL will it cause any trouble when developing the website with asp.net?

Thank you very much.