Date fields with default = now() in MS Access fail on MYSQL

[basementjack]

I came across a situation when trying to convert my Access database.

The create tables generated had statements like
Create table xxxx (
entrydate DATETIME NOT NULL DEFAULT 'now()',
xxx
xxx
)

The create table statement fails, because the default value is invalid.
Is it possible to have an option to convert these to
entrydate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP


?

I'd assume something similar probably would benefit the Access to MSSQL product as I think it needs GetDate() instead of Now()

If the source of this is available, I'd be happy to rough in the code and submit it back up.

- Jack

[jr]

Hi,

This will be fixed in the next version.

Regards,
Jacob

[jr]

This has now been released :-)

/Jacob