as your target system should be mysql ...

but in the past I had troubles with access, too, when applying generated datamodels from powerdesigner to access it fails while only switching to sybase or oracle it works fine

to me access is not a real rdbms but other may have another opinion about it ...